I have a database in Firebird(Interbase) that has 106 million records
at 37.4 gig.
I imported the database into mySQL and built the same indexes.
with a query like this:
select * from experian.experian where latitude >= '038631928' and
latitude <= '038638092' and longitude >= '096671646' and longitude <=
'096680757';
Interbase takes 10 seconds to return 70 records, but mySQL takes 18 seconds
to return the same record count.
Is there any way to speed up mySQL?
my Index is:
ALTER TABLE EXPERIAN.EXPERIAN ADD INDEX latlong (latitude,longitude);
Both fields are 9 chars long.
"explain" says it is using the latlong index with a key length of 20.
Is this the best mySQL will do? Is there a better sql statement I can use?
mike
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 10, 2002 10:08 AM
To: Mike Grover
Subject: Re: mySQL vs Interbase
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter you must include
one of the following words in your message:
database,sql,query,table
If you just reply to this message, and include the entire text of it in the
reply, your reply will go through. However, you should
first review the text of the message to make sure it has something to do
with MySQL. Just typing the word MySQL once will be sufficient, for example.
You have written the following:
SSBoYXZlIGEgZGF0YWJhc2UgaW4gRmlyZWJpcmQoSW50ZXJiYXNlKSB0aGF0IGhhcyAxMDYgbWls
bGlvbiByZWNvcmRzDQphdCAzNy40IGdpZy4NCg0KSSBpbXBvcnRlZCB0aGUgZGF0YWJhc2UgaW50
byBteVNRTCBhbmQgYnVpbHQgdGhlIHNhbWUgaW5kZXhlcy4NCg0Kd2l0aCBhIHF1ZXJ5IGxpa2Ug
dGhpczoNCg0Kc2VsZWN0ICogZnJvbSBleHBlcmlhbi5leHBlcmlhbiB3aGVyZSBsYXRpdHVkZSA+
PSAnMDM4NjMxOTI4JyBhbmQNCmxhdGl0dWRlIDw9ICcwMzg2MzgwOTInIGFuZCBsb25naXR1ZGUg
Pj0gJzA5NjY3MTY0NicgYW5kIGxvbmdpdHVkZSA8PQ0KJzA5NjY4MDc1Nyc7DQoNCkludGVyYmFz
ZSB0YWtlcyAxMCBzZWNvbmRzIHRvIHJldHVybiA3MCByZWNvcmRzLCBidXQgbXlTUUwgdGFrZXMg
MTggc2Vjb25kcyANCnRvIHJldHVybiB0aGUgc2FtZSByZWNvcmQgY291bnQuDQoNCklzIHRoZXJl
IGFueSB3YXkgdG8gc3BlZWQgdXAgbXlTUUw/DQoNCm15IEluZGV4IGlzOg0KDQpBTFRFUiBUQUJM
RSBFWFBFUklBTi5FWFBFUklBTiBBREQgSU5ERVggbGF0bG9uZyAobGF0aXR1ZGUsbG9uZ2l0dWRl
KTsNCg0KQm90aCBmaWVsZHMgYXJlIDkgY2hhcnMgbG9uZy4NCg0KImV4cGxhaW4iIHNheXMgaXQg
aXMgdXNpbmcgdGhlIGxhdGxvbmcgaW5kZXggd2l0aCBhIGtleSBsZW5ndGggb2YgMjAuDQoNCklz
IHRoaXMgdGhlIGJlc3QgbXlTUUwgd2lsbCBkbz8gSXMgdGhlcmUgYSBiZXR0ZXIgc3FsIHN0YXRl
bWVudCBJIGNhbiB1c2U/DQoNCiAgbWlrZQ==
