search

tbayart / sql-server-data-producer

Automatically exported from code.google.com/p/sql-server-data-producer
0 stars 0 forks source link

Performance of reading table information needs to be improved. #93

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
When "analyzing" a database the process can be really slow if there is alot of 
tables.

This is because of the way columns are read in a cursor based matter but mainly 
because the foreign keys are read at the same time.

Fix:
1: Read all the tables and their columns set based.

2:Try to read the foreign keys in a background worker thread instead.

Original issue reported on code.google.com by a03pe...@gmail.com on 15 Nov 2012 at 11:51

GoogleCodeExporter commented 9 years ago 
Fixed some related bugs
Each table opened its own connection
Foreign key cache did not work as intended, it was getting the rows from the db 
each time.

Original comment by a03pe...@gmail.com on 29 Nov 2012 at 3:40