Hi,
I'm running MySQL 4.0.17-nt, and for some reason the my.cnf file in my
C:\ directory got renamed around the time we rebooted the server last.
Now the global variable innodb_buffer_pool_size is set to a small value,
and my queries are taking a long time to execute. I don't want to
restart the
Well, there are people who feel that tables should be linked by foreign keys
to ensure referential integrity. Everyone who uses MySQL gets by without
them though. Its up to your coding to make sure referential integrity is
not violated.
Although foreign keys are left out of MySQL for performanc
1
DESC LIMIT 1
In testing the second statement seems slower than the max() for some reason
though.
Is there anyway to get close to a O(logN) search time on these queries?
Thanks again,
Dave
-Original Message-
From: Dave Dutcher [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 24, 2002 1
I was wondering if somebody could give me any suggestions on how to optimize
a query I am working on.
This is my table:
CREATE TABLE testdata (
Begin char(9) NOT NULL default '',
End char(9) NOT NULL default '',
UNIQUE KEY BeginEndIndex (Begin,End)
) TYPE=MyISAM;
It is a table of ranges.
