Subject | Re: How to make my report quicker |
---|---|
Author | heroes3lover |
Post date | 2007-05-27T23:27:34Z |
Thanks,
The sales history table
48,000,000 rows/month
and the zip file of the database file already been more than 70G
It's crazy, so I think the best way to fix the problem of report is
not totally based on the SQL performance,
I'm prefer some good idea on database design or something else
Regards,
Roc
The sales history table
48,000,000 rows/month
and the zip file of the database file already been more than 70G
It's crazy, so I think the best way to fix the problem of report is
not totally based on the SQL performance,
I'm prefer some good idea on database design or something else
Regards,
Roc