"all Rows" For Large Tables

[bfischer1121]

When I'm working with small amounts of data, SQLyog storing my preference for “All rows” or “Rows in a range” is a nice touch. However, when the table is populated with millions of records, SQLyog will still try to return all rows. This crashes my machine every time. I don't know how to change this preference without switching to the “Table Data” tab which causes the crash in the first place. It'd be great if SQLyog did a quick count query first to see if returning all the records is feasible and, if in doubt, presents a warning first asking whether to proceed or not before grinding to a hault. Thanks for the excellent product.

[Aparna]

Hi,

Quote:

I don't know how to change this preference without switching to the “Table Data” tab which causes the crash in the first place.

Well as of now there is no such preference option. But the following two solutions can be used as a work around:

1. While a huge table is getting loaded please push the stop option(as shown in the screen shot stop_option) and change it to rows in a range so that the application does not crash. Does this help in your case?

2. To make sure that by default SQLyog considers rows in a range while loading any table you can do the following:

I. Goto the run option

II. Type %appdata%

III. The appdata folder opens up and inside this there will be a folder by name SQLyog. Open SQLyog and rename the file ColumnAttributes.db so that everytime you load a table rows in range will be taken as the default option.

If you have any more questions please feel free to ask us. We will try to find a solution for this.

Regards,

Aparna

[Author]

Posts