[Mod_log_sql] How many records is to many?

Carl Edwards edwards at vitesse.com
Mon May 16 18:28:24 EST 2005


Hello,

Could someone give me a feel for how much data you store in
one table?  Do you move your stats to other tables by month,
year, or some threshold #?  There must be a tradeoff between
not having indexes which makes the INSERTs faster and having
them which makes the SELECTs faster, but at only 70k records
my multiple table joins take about 3 min.

Thanks,
/Carl



More information about the Mod_log_sql mailing list