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

1 files changed, 1 insertions, 1 deletions

diff --git a/CustomQuery.m b/CustomQuery.m
index 2dd43fc4..e5f48e7b 100644
--- a/CustomQuery.m
+++ b/CustomQuery.m
@@ -85,8 +85,8 @@ sets the tableView columns corresponding to the mysql-result
 	if ( nil != theResult )
 	{
 		int r = [theResult numOfRows];
+		if (r) [theResult dataSeek:0];
 		for ( i = 0 ; i < r ; i++ ) {
-			[theResult dataSeek:i];
 			[tempResult addObject:[theResult fetchRowAsArray]];
 		}
 		queryResult = [[NSArray arrayWithArray:tempResult] retain];