[smine]

Manoj wrote on May 5 2009, 09:27 PM:

Hi,

Can you try by enabling Autocomplete and disabling “Always rebuild tag files on startup”?

this does seem to have helped. there is still a bit of a delay when i type a few chars, but it now starts out at no more than a second. the characters on the screen appear “jerky” but it is much better than 10 seconds! 🙂

also, i have noticed that in all cases, the delay becomes shorter the longer that i have SQLyog open. when i first start SQLyog (and enable “Always rebuild tag files on startup”) then typing 2-3 chars of a word causes the 10-15 sec delay. after using SQLyog for a while (i cannot say exacly how long, but more than just a few minutes), the delay becomes shorter and eventually the UI is responsive.

so it does seem like maybe it is related to the tag database? my server contains over 150 databases and some of those databases contain over 250 tables. tables don't usually have more than 40-50 columns but there are many unique column names and they tend to be long names.

is there anything else i can/should try?

[smine]

interesting question! the machine is Dell Optiplex GX620 with Dell wired USB keyboard. i have a Logitech wireless mouse.

i also noticed that in the C:Documents and SettingsusernameApplication DataSQLyogTags directory (which i assume is related to Autocomplete) there is a .db file that is 25.6 MB. i don't know if that is large or small or size doesn't matter.

[smine]

yes, turning off Autocomplete returns SQLyog Enterprise to same responsiveness as Community. turning on Autocomplete immediately introduces the 10-15 second delay as soon as i begin typing a query.

this is very disappointing as i purchased Enterprise primarily for the convenience of Autocomplete. maybe there is some way to speed it up?

by the way, i am using Windows 2000 SP4 (i know it's old, but there are reasons i cannot upgrade).

[smine]

Mahesh wrote on Mar 3 2009, 11:24 PM:

1) Can u please attach a table structure along with sample data where it is reproducible consistently?

2) If Possible attach a screenshot of settings in Export CSV option ?

i have attached a screenshot of Export CSV.

i have attached a text file of the result set saved as CSV and saved as XML and as SQL so you can see the difference. both XML and SQL are correct, the CSV is corrupted.

other than that, i'm not sure what data you want. the entire results set exported as XML format? exported as SQL format? i have only seen this problem on large exported datasets, several megabytes in size. do you want 5 or 6 MB of data? i cannot provide the source tables for you to run the query and obtain results.

[smine]

the table is a little confusing. the INSERT INTO statement is the data. t.xml was created using SQLyog Table | Export | Export Table Data as XML. the XML has 21 rows with 3 columns named “num” [int(1) unsigned, NOT NULL], “table_name” [varchar(255), NULL] and “query” [longtext, NULL]. the “query” column contains the “INSERT INTO…” and it is data.

the original posting told me to export, which is what i did–i didn't know about the dump. i have now done the SQL-dump and attached it to this posting as table_names.zip. sorry for the confusion! 😕

[smine]

hi! the clipfailzip file i provided includes exported table data (named t.xml) that fails. i thought that was what you were asking for. i'm not sure what is a SQL-dump? when i get the failure, SQLyog simply exits, no error message, no dump.

p.s. i tried downloading clipfail.zip from the earlier posting and WinZIP says it is corrupt. i have re-uploaded it with this msg. before uploading, i confirmed that i can successful open clipfail.zip and it contains the same data as the first one i uploaded, so if the first one worked okay for you, there is no need to look at the second one.

[smine]

hi! just checking to see if i've provided enough info to help diagnose the issue. if you need anything else, please let me know. thanks!

[smine]

hi!

1) i have attached clipfail.zip. it includes (a) t.xml which is the exported table and (b ) clipfail.avi which is a very short video clip of the failure. NEW INFO! i discovered this morning that it does not fail the first time i copy to clipboard but it does fail the second time. you will see this in the clip. sorry i didn't realize that yesterday. (also, the query result is now 21 rows instead of 14.)

2) before open SQLyog, TaskManager reports 1046600K total and 490800K available. i open SQLyog and run the query that returns 49614 rows. now TaskManager reports 463180K available. i try to Copy All Rows to clipboard, SQLyog says not enough mem. NOTE: Taskmanager now says 505700K available! i open WinSQL and run the query, TaskManager now says 496500K available. i copy to clipboard in WinSQL, it succeeds and TaskManager says 400000K available.

i can give you a short video showing what happens in item (2) like i did for item (1), but i will wait for you to request it since i'm not sure how helpful it will be and i don't want to make this ZIP much larger than it already is.

thanks!

[Author]

Posts