Sorting Data Returned From Database

[noisefloor]

Hi,

I did initially try something like that with 3 tables as you suggested, but I think with a large amount of data it was quite slow using a SQL query.

That's hard to imagine - assuming the tables, relations and indexes were set-up correctly. Do you still have the CREATE TABLE statements you used?

Except this: 1600 lines is not a lot of data at all. Database are geared towards hundered thounds or millions of data base rows. Also for in-memory processing and possible manually iterating of the data 1600 lines are not a lot. What can make it slow is using slow algorithms or a poor set-up of the DB tables.

Regards, noisefloor