Bug #26025 MySQL Query Browser Text Importer uses high cpu in big imports

• Submitted: 1 Feb 2007 18:41
• Modified: 7 Feb 2007 13:57
• Reporter: Dincer Kavraal
• Status: Won't fix
• Category: MySQL Query Browser
• Severity: S3 (Non-critical)
• Version: 1.2.9.0
• OS: Windows (MSWindows 5.1.2600)
• CPU Architecture: Any
• Tags: cpu, high, import, load, Mysql Query Browser, regex

[1 Feb 2007 18:41] Dincer Kavraal

Description:
MySQL Query Browser tool Regex Text Importer agent tries to open whole text file, when you show the file to import, in the visual form. Same happens on "preview" function. If the file to be imported is huge, then uses makes an enourmous cpu load.

How to repeat:
1. Open MySQL Query Browser
2. Click menu: Tools -> Regex Text Importer
3. Click button: "Load Source Text"
4. Select a file that is bigger such 1GB.
5. Write a regular expression like ^(.*)$ (which to select each line)
6. Click button "Preview"

It will try to preview(!) whole script.

Suggested fix:
There can be a limited preview for whole file and the generated script like top 5 lines.

Then, when you click "Execute" or "Store SQL to Script" then it can do whatever it must.

[7 Feb 2007 13:57] Mike Lischke

The regex importer tool is a third party contribution and not supported by us.