byrdfarmer
Vendor
Hey yall. I got a batch process that loads about a million records from one table into five other tables. It uses prepared cursors to do the select intos by the way. Well, we see that this job runs like a dog during the business day but after hours and on weekends it flys like no get out!
On business days the only thing going on is that we have around a hundred or so users doing lookups (read only) from the five tables that we are insert ing to with this batch job. Can someone explain to me why these lookups slow down my inserts so much?
On business days the only thing going on is that we have around a hundred or so users doing lookups (read only) from the five tables that we are insert ing to with this batch job. Can someone explain to me why these lookups slow down my inserts so much?