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


Subject
Views
Written By
Posted
Geolocating Database Performance
2477
January 24, 2005 01:05AM
1770
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.