Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Posts
    1

    Unanswered: Large Table performance

    Hi,
    I have a large MyIsam table with 15 NUmeric fields and 3 BigText fields. When the data grows over 500000 rows, select performance goes down rapidly to over 90 seconds. What options do I have to speed up the select operation. Will InnoDB be better than MyIsam?

    Regards,
    Ash

  2. #2
    Join Date
    Sep 2002
    Location
    Montreal, Canada
    Posts
    224
    Provided Answers: 1

    Re: Large Table performance

    Originally posted by chillinmoon
    Hi,
    I have a large MyIsam table with 15 NUmeric fields and 3 BigText fields. When the data grows over 500000 rows, select performance goes down rapidly to over 90 seconds. What options do I have to speed up the select operation. Will InnoDB be better than MyIsam?

    Regards,
    Ash
    Can you be more specific? Do you have an EXPLAIN for the problematic queries and a DESCRIBE of the involved tables and a SHOW INDEX?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •