will it cause any problem to my site if i put 1 day interval

in the database maintenance, clear cache templates_c and clear session options

what is the recommended day interval for big site and small site ?

No, i will cause no problem.
There is no need to every day check the consistency of the DB, except for very large websites.
About clearing sessions, if you are the only one to connect to your website, there is no need to clear every day
About cache, and templates_c, clear theme daily only if you have hig traffic and plenty of accessed content's pages

Moreover, there are other parameters to set to improve your website speed display : image optimization, css/html optimization, etc., gzip. About this latest one, i've reported yesterday a bug, and i've noticed too it slowed my website.

thank you marco for the explanantion

btw...what is the bug that you found in the module? do you have any quick fix...i noticed my site has been slow lately don't know if this related to xoopscare

not, it's not about the xoopscare module, but it deals with XOOPS core (gzip) : activating gzip don't help EMLH hack to work and slowes the website
marco