How many records is to many?

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
_______________________________________________
Download the latest version at http://www.outoforder.cc/projects/apache/mod_log_sql/

To unsubscribe send an e-mail to 
mod_log_sql-unsubscribe-7qY7E20V6GW73k+5HYS8LQqVMODqnSLI@public.gmane.org