Arrays as MySQL

[silkfire]

I read somewhere there was a class that allowed you to work with MySQL but instead of tables you get all your data into one array, then you can SELECT on that array.

 

The reason I'm asking I want to perform queries on this smaller set of data taken from a 10,000+ rows database which is slow. 1 query into the array takes 1 sec so that's fast.

 

I especially need sorting functions. In PHP you can only sort f.ex. by key or value, I want to multiple sort like in MySQL: ORDER BY age, name, id, score.

 

Throw your ideas at me Just so you know I really want this array solution I don't want to hear any "optimize database/query" talk.

[gizmola]

If you have 10k rows in a mysql table, and you can't get a reasonable subset of the data in milliseconds, there is something wrong with your approach.  There are ways to performance tune the data.  In order to do anything with an array, you first have to read the entire contents into memory.  That is going to take a while. Yes arrays are hashed on their key, which is very efficient, and this is key, once the data is read into the array!  But that sort of efficiency already exists in the database, if you have normalized structures and have appropriate indexes and done explain on the queries, so that you are clear on how the queries are being optimized.