MySQL Forums
Forum List  »  Performance

Geolocating Database Performance
Posted by: Ted Piotrowski
Date: January 24, 2005 01:05AM

I recently purchased a geolocating database to track the location of the users that access my website. I imported it into mysql as a single table, but the database is fairly large >300MB. I find that query times on it are substantially slower than they are for other databases I use. (The tables are correctly indexed)

Since this database is basically read-only, is there some way I can exploit this characteristic to increase performance. Keep it stored in RAM, eliminate concurrency, logging, etc.

Server stats: 3.0 Ghz Pentium Xeon, 2GB Ram

Options: ReplyQuote

Written By
Geolocating Database Performance
January 24, 2005 01:05AM
January 24, 2005 02:34AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.