Re: Need Help in Mysql database
| From: | Bastien Koert | Date: | Wed, 30 Jun 2010 17:13:17 +0000 |
| Subject: | Re: Need Help in Mysql database | ||
| References: | 1 | Groups: | php.db php.windows |
| Request: | Send a blank email to php-db+get-47242@lists.php.net to get a copy of this message | ||
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