Hi, I'm trying to learn a little about query optimization.. I have a query that is
pretty slow, and was wondering if there is an easy way to speed it up.
mysql> EXPLAIN
-> SELECT
-> mailfrom,
-> sum((msgsize)/100) as mb,
-> count(id) as count,
-> avg(hits) as
i have a datbase of about 1.5 million log entries that i want to search based on
subject (not indexed because it's seldom used). when i try, i get a fatal warning
that i cant seem to kick. i have rtfm, and changed max_join_size=200 in my.cnf to
hopefully make it run without the fatal warni
Thursday, October 24, 2002 10:32 AM
> To: [EMAIL PROTECTED]
> Subject: RE: DBI Connect Fails after 20,000 record inserts/updates
>
>
> Do you connect/disconnect before/after every insert?
>
> -Original Message-
> From: Dallas Engelken [mailto:dallase@;nmgi.com]
> Sent
m. Box is a dual p3, 2gig ram, 72gig SCSI RAID 5.
Lookin for ideas here! Thanks for any help.
Dallas Engelken
NMGI
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
