On Fri, 25 Feb 2005, Chris Aitken (The Web Hub) wrote: > Its highly possible as this is the first database ive had to use with a > large number of records. I shall look into indexing part of databasing now. > Any suggested places to start that explains it helpfully ?
One way to do it, would be to set up an identical table with a smaller dataset that you can run tests on. You need to analyze your SELECT statements and figuring out where an index would be appropriate. You should use EXPLAIN to see what index changes have resulted in; it will show you how the storage engine finds the data and if it was able to use any indexes. Links: http://dev.mysql.com/doc/mysql/en/explain.html http://dev.mysql.com/doc/mysql/en/mysql-indexes.html If you're still having issues, show us your table design. :) Atle - Flying Crocodile Inc, Unix Systems Administrator -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
