Faster method needed...

[Anon]

I need to update about 8000 records in a table containing 40000 records. Updating each record individually takes far too long, so I want to read the table into my memory, manipulate the data, and then rebuild the entyre table alltogether.
I've been adding the data of each field into a corresponding array, but it seems impossible to search through my arrays for a speciffic fields. Does anyone know how to do this, or do you have another sollution?

array_search() doesn't work on my compilation, so I feel crippled...

Thanks.

Alex

[Anon]

Maybe you don't need only a workaround for your 8000 updates.
What are you going to update ?
A time-field, an integer-counter, or what ?

[Anon]

Integer values no higher than 100, generated from a php-script.

[[deleted]]

Why do so many people think they can out-smart a database server? :-)

How long is "far too long"?
Did you optimize your database server?
Do you use indexes?

Loading everything into memory is doable, but you
are just re-writing the database engine, and I doubt PHP's array-handling
is much faster than your database.
(after all, you'll be reading 40k records, editing 8k, then re-loading 40k)

If you are using PG-SQL or some other transaction-enabled, use only a few transactions, so you can get a few hunderd updates in one transaction.
And for any kind of database: give it lots and lots of memory.

[Anon]

The question, what you are doing with these integers....which purpose...
Maybe there exists a trick to simulate the much updates with a little procedure...