search

alzalabany / sql-buddy

Automatically exported from code.google.com/p/sql-buddy
MIT License
0 stars 0 forks source link

Counting table rows on login is slow #1

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
On a server with ~35 databases (with 5-100 tables each) login takes more
than 1 minute. This is because counting rows on each table is slow.

I attach an SVN patch that adds a setting to control this.

Original issue reported on code.google.com by dare...@gmail.com on 30 Aug 2008 at 4:01

Attachments:

GoogleCodeExporter commented 9 years ago 
Used setting for dboverview too. Because opening some databases needs 10-20 
seconds.

I am looking into reading the row count (approximate) from MySQL's
information_schema.tables (field table_rows)

Original comment by dare...@gmail.com on 30 Aug 2008 at 4:16

Attachments:

GoogleCodeExporter commented 9 years ago 
Using a setting for this (as I do in the patches) is not a perfect solution. The
right way is the information_schema. I'll look some more into this.

Original comment by dare...@gmail.com on 30 Aug 2008 at 8:35

GoogleCodeExporter commented 9 years ago

Original comment by dare...@gmail.com on 30 Aug 2008 at 8:46

GoogleCodeExporter commented 9 years ago 
Added method in SQL to return metadata. For MySQL it uses the 
information_schema.

Original comment by dare...@gmail.com on 30 Aug 2008 at 10:34

GoogleCodeExporter commented 9 years ago 
Has this been fixed in the latest release?

Original comment by geoffrey...@gmail.com on 8 Jul 2011 at 10:03