Re: 30M rows - is dynamic sorting and selecting even possible?

[Craig Logan]

ok, I sorted the innodb thing. my.cnf was not taking the changes yesterday but today it worked. innodb_buffer_pool_size is now set to 500M.

as for the left-off thingy... that's ugly indeed. but the main drawback is, I would have to provide the date as GET variable which would mean it could be modified by the user, leading to possible manipulations that are hard to catch. I guess I could stick the vars into a session var though... hum...

ok, let's assume that'll work... is there any way I can force all the data into the cache? when I run a query twice, the result is obviously taken from the cache as the query takes 0.00 seconds, but is it possible to influence when the data is cached? it would be odd if the first user who lands on page x has to wait 30 seconds for the results...



Edited 1 time(s). Last edit at 04/17/2009 07:40AM by Craig Logan.