Strings in sql queries

Question

Strings in sql queries

Viewing 4 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 1

What is blocking you from automating this process and not having to intervene at all?

Carlos Urbina SSCommitted Points: 1850 More actions · Answer 2

If you were to test the 10,000 updates on an empty table, would it still take 20 minutes? What I suspect that it is not the string functions that are slowing down the process but indexes, constraints and possibly triggers. If you run 10,000 updates on an empty table and it takes 20 minutes, then begin to address and optimize the string functions. If the 10,000 updates are fast, (less than a minute ), then look for excessive indices, constraints or triggers (one slow process I researched once had over 10 indices, about 17 referential integrity constraints and half a dozen update/insert triggers, none of which the system owner wanted or could give up).

p.s. Please remember that most of us don't know what a lakh is; i assumed it is a million or a billion

Sreejith Sreedharan SSCertifiable Points: 5403 More actions · Answer 3

FYI 1 lak is 100 K.100K should not take long to process.

Bala Sivaraman SSC Enthusiast Points: 102 More actions · Answer 4

Try using an Index on this column.

Also, if this table has a lot of inserts/deletes...i suggest u do a re-index every night.