Hi peeps,
I've got a table which is basically a log of traffic on one of my websites
- I have a seperate table per month, all of which are MERGED for queries
which need access to more than a month's worth of data.
select count(distinct cookie) as c,dayofmonth(event_time) as d from
tbl_webevents where event_time >= '2001-02-01 00:00:00' and
event_time < '2001-03-01 00:00:00' group by d;
This query currently takes in excess of 20 seconds to return a result
(tbl_webevents is the merge table, consisting of 6 x 250,000 row table).
Does anyone have any suggestions as to whether this could be sped up ? All
ideas welcome!
Thanks,
P
---------------------------------------------------------------------
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
