HI
I am very pleased to join this forum

I am new to SQL programming , I am facing a challenge our sql server database entry is crossing 1lakh per day,so connection becomes slow....

For this how can i handle the situation!!
our databases deals with leads and hits in affiliate website..

Thanks in advance.

Are you talking about MS SQL Server?

First profile your existing queries, determine the bottle neck query. See if you can gain some performance by optimizing that query, applying different indexes etc. (Google: query performance)

When you are sure all are near optimal, adjusting database settings is an option.