From f4ba50508f2c89b3ca5df46a7ec09e0002f7e2e5 Mon Sep 17 00:00:00 2001 From: rowanbeentje Date: Sat, 6 Dec 2008 22:34:18 +0000 Subject: - 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. --- English.lproj/MainMenu.xib | 194 ++++++++++++++++++++++++++++++++++----------- 1 file changed, 147 insertions(+), 47 deletions(-) (limited to 'English.lproj/MainMenu.xib') diff --git a/English.lproj/MainMenu.xib b/English.lproj/MainMenu.xib index 98e0d476..dc404fea 100644 --- a/English.lproj/MainMenu.xib +++ b/English.lproj/MainMenu.xib @@ -316,7 +316,7 @@ - Table Content Result + Current Table 1048576 2147483647 @@ -324,7 +324,7 @@ submenuAction: - Table Content Result + Current Table YES @@ -350,6 +350,42 @@ + + + Current Browse View + + 1048576 + 2147483647 + + + submenuAction: + + Current Browse View + + YES + + + CSV file... + + 1048576 + 2147483647 + + + 8 + + + + XML file... + + 1048576 + 2147483647 + + + 9 + + + + Custom Query Result @@ -371,7 +407,7 @@ 2147483647 - 8 + 10 @@ -381,7 +417,7 @@ 2147483647 - 9 + 11 @@ -407,7 +443,7 @@ 2147483647 - 10 + 12 @@ -417,7 +453,7 @@ 2147483647 - 11 + 13 @@ -3608,22 +3644,6 @@ 677 - - - exportTable: - - - - 679 - - - - exportTable: - - - - 680 - exportMultipleTables: @@ -3792,6 +3812,38 @@ 813 + + + export: + + + + 825 + + + + export: + + + + 826 + + + + export: + + + + 827 + + + + export: + + + + 828 + @@ -4076,6 +4128,7 @@ + @@ -4098,26 +4151,6 @@ - - 386 - - - YES - - - - - - - 403 - - - - - 404 - - - 394 @@ -5729,6 +5762,55 @@ + + 386 + + + YES + + + + + + + 404 + + + + + 403 + + + + + 821 + + + YES + + + + + + 822 + + + YES + + + + + + + 823 + + + + + 824 + + + @@ -6265,6 +6347,15 @@ 81.editorWindowContentRectSynchronizationRect 82.IBPluginDependency 82.ImportedFromIB2 + 821.IBPluginDependency + 821.ImportedFromIB2 + 822.IBEditorWindowLastContentRect + 822.IBPluginDependency + 822.ImportedFromIB2 + 823.IBPluginDependency + 823.ImportedFromIB2 + 824.IBPluginDependency + 824.ImportedFromIB2 83.IBPluginDependency 83.ImportedFromIB2 92.IBPluginDependency @@ -6571,7 +6662,7 @@ Y2hhbmdlIHRoZSBvcmRlcg com.apple.InterfaceBuilder.CocoaPlugin - {{555, 251}, {213, 93}} + {{555, 231}, {213, 113}} com.apple.InterfaceBuilder.CocoaPlugin {{399, 465}, {213, 93}} @@ -6581,17 +6672,17 @@ Y2hhbmdlIHRoZSBvcmRlcg com.apple.InterfaceBuilder.CocoaPlugin - {{655, 360}, {136, 43}} + {{768, 271}, {136, 43}} com.apple.InterfaceBuilder.CocoaPlugin com.apple.InterfaceBuilder.CocoaPlugin - {{655, 340}, {136, 43}} + {{768, 231}, {136, 43}} com.apple.InterfaceBuilder.CocoaPlugin com.apple.InterfaceBuilder.CocoaPlugin - {{655, 320}, {136, 43}} + {{768, 211}, {136, 43}} com.apple.InterfaceBuilder.CocoaPlugin com.apple.InterfaceBuilder.CocoaPlugin @@ -6910,6 +7001,15 @@ Y2hhbmdlIHRoZSBvcmRlcg com.apple.InterfaceBuilder.CocoaPlugin + {{768, 251}, {136, 43}} + com.apple.InterfaceBuilder.CocoaPlugin + + com.apple.InterfaceBuilder.CocoaPlugin + + com.apple.InterfaceBuilder.CocoaPlugin + + com.apple.InterfaceBuilder.CocoaPlugin + com.apple.InterfaceBuilder.CocoaPlugin @@ -6934,7 +7034,7 @@ Y2hhbmdlIHRoZSBvcmRlcg - 813 + 828 -- cgit v1.2.3