aboutsummaryrefslogtreecommitdiffstats
path: root/TablesList.m
diff options
context:
space:
mode:
authorrowanbeentje <rowan@beent.je>2008-12-06 22:34:18 +0000
committerrowanbeentje <rowan@beent.je>2008-12-06 22:34:18 +0000
commitf4ba50508f2c89b3ca5df46a7ec09e0002f7e2e5 (patch)
tree1231d2377cde94c021d34394620a0dbbc3e185bd /TablesList.m
parent1a7130fea502cf627897984fc5a8453e9df9ab00 (diff)
downloadsequelpro-f4ba50508f2c89b3ca5df46a7ec09e0002f7e2e5.tar.gz
sequelpro-f4ba50508f2c89b3ca5df46a7ec09e0002f7e2e5.tar.bz2
sequelpro-f4ba50508f2c89b3ca5df46a7ec09e0002f7e2e5.zip
- Identified and corrected a major n^2 bottleneck in working with all query result sets - when iterating through a mysql result set, all the data up to each row was seeked through again. With this fixed SP can work with very large result sets at much, much higher speeds.
- Fixed incorrect query splitting in splitQueries - improves custom queries and imports. - CSV export now exports NULLs as an empty cell (eg "1,,3"). This resolved Issue #67. Correspondingly, CSV import now also accepts this syntax. - CSV and SQL exports no longer quote numeric values for file size and neatness improvements. - Multi-table exports now show progress through the tables in the text description, and use the progress bar for export of each table, for improved feedback. - The old "Export Table Content" menu has been split into two - "Current Browse View" which matches the old behaviour, and a new "Current Table" entry. This addresses Issue #97. - Exports now write data to a file stream as data is processed for export, and also parse data from the database as a stream where possible. This leads to lower memory usage, speed improvements, and much more accurate and constant feedback. - The export processes have been restructured and rewritten for further speed and memory improvements. - SQL exports now correctly export BLOB and TEXT contents ready for re-import into all systems. - SQL exports now group multiple VALUES for each INSERT INTO command for much, much faster imports of exported data.
Diffstat (limited to 'TablesList.m')
-rw-r--r--TablesList.m3
1 files changed, 1 insertions, 2 deletions
diff --git a/TablesList.m b/TablesList.m
index 32104d9b..500ac349 100644
--- a/TablesList.m
+++ b/TablesList.m
@@ -52,9 +52,8 @@ loads all table names in array tables and reload the tableView
[tables addObject:NSLocalizedString(@"TABLES",@"header for table list")];
theResult = (CMMCPResult *)[mySQLConnection listTables];
-
+ if ([theResult numOfRows]) [theResult dataSeek:0];
for ( i = 0 ; i < [theResult numOfRows] ; i++ ) {
- [theResult dataSeek:i];
[tables addObject:[[theResult fetchRowAsArray] objectAtIndex:0]];
}