Posted by Andy Hassall on 02/11/06 00:23

On 10 Feb 2006 14:17:24 -0800, "frizzle" <phpfrizzle@gmail.com> wrote:

>I have a news management system, with a mySQL backend.
>I tested it yesterday with 1.000.000+ records, testing my url system.
>I pulled out records calling them by the url field. It was incredibly
>fast, but now,
>when i call 5 records, ordered by date (which were inserted randomly)
>it's incredibly slow. And i only have 100.000 records left at the
>moment.
>My database structure is below, and i son't know how i could get it to
>run
>any faster ...

You should learn to use the EXPLAIN command, which shows how MySQL is
executing the query. You can use this information to make changes to your
schema, the simplest of which is adding extra indexes to support your queries.

Follow-ups set to comp.databases.mysql.

--
Andy Hassall :: andy@andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool

[Back to original message]