Table Data Scrolling Error

[ffortino]

Using SQLyog Comm Ed v8.05 and v8.1

When viewing Table Data on large tables > 1 million records

scrolling does not function correctly.

Every time I drag the scroll bar down, it pops back up ?

I also tried the Ent version, and it also fails.

Is this a bug?

Will it be fixed?

Thanks,

[peterlaursen]

This is a reply that I am not 100% sure about (but 99.5% sure). I think you scroll faster than data can be 'spooled' in the data buffer. The SQLyog GRID is designed to 'animate' the scrolling ,ie. it loads while you are scrolling and displays *while scrolling* , but the larger the number of rows the more rows every millimeter of the scroll bar corresponds to.

workarounds:

1) keep the mouse at the end position for a while.

2) switch to text-mode (ctrl+l) and scrolling is much faster. But the switching also will take time.

However basically and personally I do not think it makes sense to display so many rows at a time. I would use the LIMIT/'rows in a range option' setting with << and >> buttons. Or work from RESULT tab filtering with a WHERE-clause. That is what kind of operation the program is designed for.

But I will discuss with the team if we could either:

1) make the animated mode optional, so that it will simplyonly start loading when you release the scroll button

2) automatically turn off that animated mode if it 'lacks behind' too much.

(but now sure that the internal buffer allow for neither 1) or 2) – we may use some kind of a linked list for the buffer where it is not really possible)

3) or it could remember where you released .. and then it will animate to that position at least

Just my curiousity: have you tried another GRID-based program (Excel or another spreadsheet) with equally many rows?

[ffortino]

Thanks for the help. Text mode solved my problem.

Thanks again,

Frank Fortino

______________________

peterlaursen wrote on Jun 8 2009, 12:03 PM:

This is a reply that I am not 100% sure about (but 99.5% sure). I think you scroll faster than data can be 'spooled' in the data buffer. The SQLyog GRID is designed to 'animate' the scrolling ,ie. it loads while you are scrolling and displays *while scrolling* , but the larger the number of rows the more rows every millimeter of the scroll bar corresponds to.

workarounds:

1) keep the mouse at the end position for a while.

2) switch to text-mode (ctrl+l) and scrolling is much faster. But the switching also will take time.

However basically and personally I do not think it makes sense to display so many rows at a time. I would use the LIMIT/'rows in a range option' setting with << and >> buttons. Or work from RESULT tab filtering with a WHERE-clause. That is what kind of operation the program is designed for.

But I will discuss with the team if we could either:

1) make the animated mode optional, so that it will simplyonly start loading when you release the scroll button

2) automatically turn off that animated mode if it 'lacks behind' too much.

(but now sure that the internal buffer allow for neither 1) or 2) – we may use some kind of a linked list for the buffer where it is not really possible)

3) or it could remember where you released .. and then it will animate to that position at least

Just my curiousity: have you tried another GRID-based program (Excel or another spreadsheet) with equally many rows?

[Author]

Posts