Temporary DB table

[Anon]

I have to extract about 2000 rows from at MySQL DB, do some arithmics with some of the values and then sort (order) all of the rows according to the results of these calculations.

Which is the best (best perfomance) way to do this:
1. By extracting the data from the DB and then solely manipulate them in PHP, and thereby also let PHP order them?

2. By writing the results to a temporary DB table (by using: "INSERT INTO tblTemp (fldID) SELECT (tblTemp1.fldOrder_ID + 100) .....") and let MySQL sort my results?

Thanks,
Anders, DK

[Anon]

depends on how loaded the database is...

if it is heavily loaded, just get the values, and do the processing and sorting in php (you really should never have to do it if you set up the database right and know how to write complicated queries)

if it is barely used, go nutty and make 20 temp tables, because then you don't have to worry about writing the sorting algorithms.