Caching a Mysql Table

[tempi]

Hi there,

 

I'm looking for a good strategie to cache a mysql table within the php script. I tought about a multi dimensional array. Is this the right thing to do? Is the cached table should be able to provide sorting as mysql does?

 

How can I manage that?

 

Greetings Templar

[shocker-z]

just curiouse but why would you want to cache the table when you could just call it at a different point anyway?

 

just store a variable with $result=mysql_fetch_array($query); and theres your array really.

 

Liam

[tempi]

different records from different table and I need to sort them.

 

So I try to put them in one temp-table to do an overall sorting.

 

Any better ideas are welcome...

[shocker-z]

what is the structure of your tables as it sounds like they haven't been normalized if you have to put all records into a temp table..

 

Liam

[tempi]

they have the same structure but i cannot sort table A and table B and then print it out. (it has to stay that way)

 

I need a sorting through all records from both tables. So I wan't to cache them temporarily.

 

Not I made a workaround with a temp SQL table where I sorted everthing. But PHP would be faster.

 

So would you use a multi dimensional array? Which one? Wich sort function?

 

Thanks again.

 

Tempi

[shocker-z]

surley if you can link them in php then you should be able to pull them out with SQL linked by a join or just using the WHERE clause

 

If you show us your 2 tables then we may be able to support you better.

 

Liam

[nEJC]

If I understand you correctly you can sort them at SQL level like this:

[pre]SELECT * FROM

(SELECT 'Y' FROM dual

UNION ALL

SELECT 'X' FROM dual) fake_name

ORDER BY 1[/pre]

Hope this helps...