search

buda-base / drs-deposit

Harvard DRS Deposit base
1 stars 0 forks source link

Investigate SSCursor for getReadies #63

Closed jimk-bdrc closed 6 years ago

jimk-bdrc commented 6 years ago

GetReadies is a pig. When you want it to return 200 of the next works, it can take 20 sec, because the server sproc returns 200 sets. Use SSCursor, and break up the queries into small chunks, which will take less than 30 sec to complete.

jimk-bdrc commented 6 years ago

There's no way to get the speed up to more than 0.76 calls/sec. This is because of some ferocious temporary tables in the SPROC. See commit aad1efcc