Re: Execution Time

2010-09-02 Thread Jangita
On 02/09/2010 10:53 a, Vikram A wrote: Hi, I have doubt on the execution time. Can any one help me! Which operation will take much time INSERT or UPDATE ? Thank you Vikram Depends on the type of data, but generally (and I say this lightly) inserts are faster then updates; alot depends on

Re: Execution time of "show databases" increases when fewer databasesare visible

2006-04-21 Thread Alexey Polyakov
On 4/21/06, Nico Sabbi <[EMAIL PROTECTED]> wrote: > the more databases a user has the less time it takes to execute "show > databases" and vice versa: If no rows in `show databases` output appear because some user has some table/columns privs but no db privs for a database in question, then I thi

Re: Execution time of "show databases" increases when fewer databasesare visible

2006-04-21 Thread Alexey Polyakov
On 4/21/06, Nico Sabbi <[EMAIL PROTECTED]> wrote: > Is this behaviour due to a bug or maybe my mysql tables are messed up? I'm not sure if we can call it a bug. But spending 8 seconds (and using 100% CPU) for a simple SHOW DATABASES query is a bit too much, and should be fixed. mysqld first read