Member Avatar for Subashsankar

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.

  • 2 Contributors
  • 1 Reply
  • 147 Views
  • 1 Hour Discussion Span
  • Latest Post Latest Post by pritaeas
Member Avatar for pritaeas

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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.