Rework SQL export:

 - Added an MCPStreamingResult class to MCPKit, to allow streaming results from the server including fast array access of each row
 - Tweak SQL export to use the streaming result class and to keep memory usage lower
End result is generally faster exports, more accurate progress bars, and much much lower (and consistent) memory usage.

1 files changed, 6 insertions, 2 deletions

diff --git a/Frameworks/MCPKit/MCPFoundationKit/MCPConnection.h b/Frameworks/MCPKit/MCPFoundationKit/MCPConnection.h
index 9639a742..932237d8 100644
--- a/Frameworks/MCPKit/MCPFoundationKit/MCPConnection.h
+++ b/Frameworks/MCPKit/MCPFoundationKit/MCPConnection.h
@@ -32,7 +32,7 @@
 
 #import "mysql.h"
 
-@class MCPResult;
+@class MCPResult, MCPStreamingResult;
 @protocol MCPConnectionProxy;
 
 /**
@@ -185,11 +185,15 @@ static inline NSData* NSStringDataUsingLossyEncoding(NSString* self, int encodin
 - (NSString *)prepareString:(NSString *)theString;
 - (NSString *)quoteObject:(id)theObject;
 - (MCPResult *)queryString:(NSString *)query;
-- (MCPResult *)queryString:(NSString *)query usingEncoding:(NSStringEncoding)encoding;
+- (MCPStreamingResult *)streamingQueryString:(NSString *)query;
+- (id)queryString:(NSString *) query usingEncoding:(NSStringEncoding) encoding streamingResult:(BOOL) streamResult;
 - (double)lastQueryExecutionTime;
 - (my_ulonglong)affectedRows;
 - (my_ulonglong)insertId;
 
+// Locking
+- (void)unlockConnection;
+
 // Database structure
 - (MCPResult *)listDBs;
 - (MCPResult *)listDBsLike:(NSString *)dbsName;