Ted Toporkov <[EMAIL PROTECTED]> wrote on 15/03/2005 11:04:09:
> List,
>
> I'm trying to create tables that will store data temporarily, if a php
> page generates data to fill the table, then any number of queries could
> be run on the table, and then be automatically be deleted if it's not
> queries for let's say an hour or something like that.
>
> Can this be accomplished with temporary tables, or should i just create
> static tables and then use a cron job to delete unused ones?
>
> What is the best way to approach this?
Temporary tables are private to a single Connection, and would therefore
not be an appropriate solution to this problem. If you have to do it, the
cron job appears youe best bet. However, I query the requirement. ISTM
that you are basically saying that you do not trust MySQL's cachein
ability, both to cache recently used table blocks and to cache the result
of recent queries. I would take the first approximation of trusting MySQL
and only attempting solutions such as that which you propose when you know
for certain that the system will not handle them without. Have you fully
characterised the behaviour of the system without this kludge in place?
Alec
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
