Re: The Use database command is too slow

It is a hosting solution, so users create databases for themselves if they want. On Feb 3, 2008 4:44 AM, Eric Bergen <[EMAIL PROTECTED]> wrote: > I think a better question is why do you have one database per user? > > -Eric > > > On 2/2/08, imad <[EMAIL PROTECTED]> wrote: > > I am not connecting

Re: The Use database command is too slow

I think a better question is why do you have one database per user? -Eric On 2/2/08, imad <[EMAIL PROTECTED]> wrote: > I am not connecting through MySQL. I am connecting through PHP. How > can I speed it up? > > > > > On Feb 3, 2008 12:20 AM, Saravanan <[EMAIL PROTECTED]> wrote: > > Hi, > > > > w

Re: The Use database command is too slow

I am not connecting through MySQL. I am connecting through PHP. How can I speed it up? On Feb 3, 2008 12:20 AM, Saravanan <[EMAIL PROTECTED]> wrote: > Hi, > > when you connect using mysql auto-rehash is enabled as default. It will read > and open the tables in the database when you try to use

Re: The Use database command is too slow

Hi, when you connect using mysql auto-rehash is enabled as default. It will read and open the tables in the database when you try to use the database. It may take time for database with many tables. use mysql with -A or --no-auto-rehash. shell> mysql -uroot -A shell> mysql -uroot --skip-auto-re