On Monday 10 February 2003 17:54, Octavian Rasnita wrote:
> Please tell me what should I do to make MySQL cache all the queries that
> can be cached.
>
> Can I do this if I am not the administrator of MySQL server? (on a session
> basis...).
Take a look at query cache:
http://www.mysql.co
At 06:58 PM 5/22/2002, you wrote:
>Greetings Friends,
>
>How could cache the whole mysql database in the memory? Which parameters
>would help?
>
>Regards.
>
>Ravi Verma
>916 705 3261
Ravi,
MySQL 4.x already has excellent caching. The best thing you can do
is to add the maximum amount of
Hi.
If you are using a decent operating system and have enough memory, it
will do it for you implicitly by caching the files. This is not as
fast as it could be (because the content still has to be evaluated
each time), but already gives you the main speed advantage of memory
vs. disks.
If you w
While the output you've shown could well be considered eroneous, surely
you shouldn't be relying on this sort of logic in a decent piece of code
? Or am I missing something ?
If you're trying to work out which row was inserted most recently,
shouldn't you be using your db handle lastinsert_id pa
