In the last episode (Mar 14), abdelhamid bettache said:
> "In some circumstances it can be beneficial to split into two a
> table that is scanned very often" I found these sentence in the mysql
> manual , section 12.3:Get your Data as small as possible
>
> Does every body know what are these circumstances?
Say you have a table of dated records (web log, or some other
transaction log), and you run lots of "last 24 hours" reports, you can
speed up those queries by creating Current and Old tables. You insert
into Current, and every night, shift the previous day's records into
Old.
If you create a MERGE table joining the two, you can still do queries
over both tables as though they were one, when you need to.
--
Dan Nelson
[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
