[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