UPDATE & INSERT speed improvement question

[lior3790]

Hello,

I'm working on a project which carrying a large scale of database (over 5 millions records).
I'm looking for a way to improve the communication speed with the SQL server in any way that i can find useful.

The main slowing reason that i have encounter is the INSERT and UPDATE command that can be processed for more then 2 minutes and this amount of time is unreasonable.

can anyone please advise how to do a different process method?

thanks,
Leo S

[NeoPa]

I expect you'll find that most of the time taken up is for updating the indices.
This is a trade-off.
If you take the time at update to change various indices, then you have them available for queries later on.
If you reduce your indices, you'll have a quicker update but some of your queries will run more slowly.

[scripto]

NeoPa is correct.
in addition, try to place an index on the specific column(s) you know that are updated frequently - that will help also.