Rework data storage and retrieval in TableContent and CustomQuery backing arrays, and make some editable CustomQuery improvements:

 - Switch to using arrays for row storage rather than dictionaries.  Use the data column index for table column identifiers.  
 - This fixes Issue #316 and also allows sorting by all custom query result columns using a column index rather than the name
 - Offers significant speed and memory advantages: result building is now 2x-3x faster, memory used for results storage is 30-40% lower, and result access is slightly faster.  (Note full 2x-3x speed results won't be seen - result fetching and mysql binary work isn't included in the timing)
 - No longer need to fetch the first column of data for tables containing only blob types
 - Correctly escape strings when editing CustomQuery results
 - Rewrite NSArrayObjectAtIndex to use the native CFArrayGetValueAtIndex rather than cached selectors - neater code and I think slightly faster

1 files changed, 3 insertions, 3 deletions

diff --git a/Source/TableContent.h b/Source/TableContent.h
index 7e020792..7224b361 100644
--- a/Source/TableContent.h
+++ b/Source/TableContent.h
@@ -66,9 +66,9 @@
 	
 	id editData;
 	NSString *selectedTable, *usedQuery;
-	NSMutableArray *fullResult, *filteredResult, *keys;
-	NSMutableDictionary *oldRow;
-	NSString *compareType, *sortField;
+	NSMutableArray *fullResult, *filteredResult, *keys, *oldRow;
+	NSString *compareType, *lastField;
+	NSNumber *sortCol;
 	BOOL isEditingRow, isEditingNewRow, isSavingRow, isDesc, setLimit;
 	NSUserDefaults *prefs;
 	int numRows, currentlyEditingRow, maxNumRowsOfCurrentTable;