Re: UPDATE 6m records quickly

[Peter Crosbie]

James

Thanks for the input.

I'll check the cache size and I will try reordering my program to process in chunks rather than a table at a time although I won't always be able to do that as the tables include time series data where each row is the price of a particular security at a particular point in time and I need to calc returns, trends or other values that can cross "chunks".

I have almost given up on MySQl for this application. I may continue to use it as a permanent data store and read data from it only updating in a batch fashion probably using LOAD FILE or something overnight.

I will use a simple proprietary fixed record file system for working space in my calculations.

Do you think MySQL will have server side cursors accessible from clients one day?

Peter