[prev in list] [next in list] [prev in thread] [next in thread]
List: php-db
Subject: Re: [PHP-DB] Need Help in Mysql database
From: Bastien Koert <phpster () gmail ! com>
Date: 2010-06-30 17:13:17
Message-ID: AANLkTilJbrbJceb0hsN3h-jhhwpM_3K1igh5OPFmMyGm () mail ! gmail ! com
[Download RAW message or body]
On Wed, Jun 30, 2010 at 10:52 AM, nagendra prasad
<nagendra802000@gmail.com> wrote:
> Hi All,
>
> I have a huge set of MP3 database. My problem is that when I try to search
> in my database its getting very slow. I was wondering if I split that
> database into 2 or more tables. Will this improve the speed of searching? Is
> it the best solution for my problem or is their any other solution?
>
> Best,
> Guru.
>
What are you :
a) searching on
b) have mysql indeces on
Also have you run an explain plan on the query to see if its using any indexes?
--
Bastien
Cat, the other other white meat
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic