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
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
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