Result window is slow down with many records.

[sitthichaikk]

Does any one found this ?

I try to use SQLyog with 20000 records, It's show in result window very fast!!!!!! 😮 😮

But when I try to scroll down on result or point with mouse pointer some where on scroll bar to see the data. It's slow down for update data in result window. I can see the data update line by line on result window. <_< I use SQLyog for retrieve data and put in excel then plot graph. 😀 and one more problem that i don't know. “How can i stop during retrieve the data immediately”? Note: SQLyog 4.03 & W2K Thanks

[Ritesh]

Are you talking about Result Window or the Insert/Update window?

[sitthichaikk]

I do retrive data from database server,

I'm taking about Result Window. 😀

[Shadow]

As far as I'm concerned, you can't stop while fetching data because SQLyog is single threaded app, thus its GUI will not respond while fetching data is in progress.

Why don't you use ODBC from Excel to get data straight from MySql to Excel?

[Ritesh]

From v4.05 BETA you can actually stop a query while its being executed.

[sitthichaikk]

Ritesh wrote on Mar 30 2005, 01:25 PM:

From v4.05 BETA you can actually stop a query while its being executed.

How can i stop it ? I haven't see the “stop” buttom in menu.

The SQLyog 4.05 BATA. It's show in result window very fast… 😀 😀

But if I scroll up or down with mouse wheel or move pointer by mouse It's still slow display in result window(tab “1 result”).

and the columnin result window, That you do auto column width. Can you fix mininum width or make it auto column width with range number?

example…

If “field column” have chareter less than < 5 chars and "data column" less than < 5 chars. It's will show only 5 chareter of that column. If “field column” have chareter less than < 5 chars and "data column" more than >10 chars. It's will show only 10 chareter of column.

If “field column” have chareter more than >10 chars and “data in column” less than <5 chars. It's will show only 10 chareter of column.

If “field column” have chareter more than >10 chars and “data in column” less than > 10 chars. It's will show only 10 chareter of column.

That mean the column width can be 5 to 10 chars.

Thanks.

Any idea are welcome.

[Ritesh]

How many rows are you trying to display?

Whenever you execute a query, the execute query button (green color) in the toolbar is replaced by a red stop sign. Click on it to stop a currently executing query.

Have you unchecked Tools -> Preferences -> Truncate Column Header To Max Data Size?

[sitthichaikk]

Ritesh wrote on Mar 31 2005, 09:47 AM:

How many rows are you trying to display?

Whenever you execute a query, the execute query button (green color) in the toolbar is replaced by a red stop sign. Click on it to stop a currently executing query.

Have you unchecked Tools -> Preferences -> Truncate Column Header To Max Data Size?

How many rows are you trying to display?

28660 records.

Whenever you execute a query, the execute query button (green color) in the toolbar is replaced by a red stop sign. Click on it to stop a currently executing query.

I haven't see anything change on toolbar. I'm click on execute query button then Hour Glass showing up, but the query button still green color until finished result.

May i miss some options or … ?

Have you unchecked Tools -> Preferences -> Truncate Column Header To Max Data Size?

I uncheck it . That work's fine.

Thanks

[Ritesh]

Very strange. 😮

I am using 4.05 BETA and the two screenshots below should make things more clear.

[Ritesh]

Stop query.

[sitthichaikk]

Today I try to download the 4.05 BETA again.

Wow….

I found the point differance between you and me.

You side….. you just click on your SQL command on SQL window and you click on “Execute Current Query” (Play button) or F5

My side….. I just cover my SQL command on SQL window and I click on “Execute Current Query” (Play button) or F5

that same one line SQL command but stop button will not show if i do cover my SQL command.

btw i just give you what i see on my side.

The main topic is slow down when scroll on mouse whell and scroll pointer. It's gone……. 😆 😆 😆

I found two things with new download.

One…

After my result is show on “result window” then I try to click between “result tab” and “data tab”. if i not click on the record in result window . It's cann't scroll up/down my data.

Two..

On result window. the sort function by click on field name on “result tab” is disable.

but on “data tab” It 's work…and sloooooow.. 😮 😮

my idea

Once…It's done on query command the result will show on “tab result”. and in “tab data” will same as “tab result”. if somebody want to edit in record, they can edit on “tab data”.

The “tab data” always show all record from first record to 1000(default number on that tab). It's helpfull if user know the range number of data. But if “tab data” show same as “tab result” It's a good things.

Because sometime user may not know exactlly record number. They want to have show in “tab result” and also canable edit in “tab data”.

Please try it.

Thanks

[peterlaursen]

I have a table of about 35000 records and with sqlyog 4.05 beta2 updating is not slow (apprx. ½ second)

And that's true for the data-tab and the result-tab as well.

Could it be a graphics card/driver problem ?

Mine is a geforce 2 – mx and that's no “smart” card today ….

[Ritesh]

Quote:

After my result is show on “result window” then I try to click between “result tab” and “data tab”. if i not click on the record in result window . It's cann't scroll up/down my data.

I am not sure if I understood your problem. Can you explain it a little more?

Quote:

On result window. the sort function by click on field name on “result tab” is disable.

but on “data tab” It 's work…and sloooooow

Sort and filter for Result Tab will be implemented in v4.1. When you try to sort data in Data tab, SQLyog actually sends SQL query with order by clause to MySQL. So it is MySQL which is slow in returning the data.

Quote:

Once…It's done on query command the result will show on “tab result”. and in “tab data” will same as “tab result”. if somebody want to edit in record, they can edit on “tab data”.

I think you are confused between the Result and Data tab. Result tab will show you data returned from a query. It even allows you edit data in the result. This means that you can execute a query with multiple tables and edit data of the table(s) simultaneously.

The data tab simply shows data from a particular table. This is helpful if you just want to view through the data in a table without writing the corresponding SQL code.

Quote:

The “tab data” always show all record from first record to 1000(default number on that tab).

You can change the limits using Tools->Preferences

[sitthichaikk]

I may repeat..

Quote:

The main topic is slow down when scroll on mouse whell and scroll pointer. It's gone…….

Quote:

I am not sure if I understood your problem. Can you explain it a little more?

The table in result window not get even scroll when just click select on tab. That is my point.

Quote:

I think you are confused between the Result and Data tab. Result tab will show you data returned from a query. It even allows you edit data in the result. This means that you can execute a query with multiple tables and edit data of the table(s) simultaneously.

The data tab simply shows data from a particular table. This is helpful if you just want to view through the data in a table without writing the corresponding SQL code.

fine… I got your point.

[sitthichaikk]

Quote:

The table in result window not get even scroll when just click select on tab. That is my point.

You can try on Microsoft Excel…..by switch between tab sheet then scroll wheel on mouse.

[Author]

Posts