EPUB | CHM | PDF

TMySQLDump.Properties.Limit

Top Previous Next

note Since v2.6.1

Sets maximum number of rows to be retrieved from server at once during dumping tables.

Syntax:

property Limit : Cardinal; default 1024;

Description:

This property value limits number of rows to be retrieved from server at once during dump process. For example, a table with 2050 rows will be retrieved in 3 times - the first 1024 rows, the second 1024, and the final 2 rows. This allows to limit memory usage for large tables dumping. You can reduce this value if you're dumping really huge BLOB fields.

note This property doesn't correlate with ExtInsertCount property. ExtInsertCount property value is used when dumped data are being saved to a file, meanwhile Limit property value is used when data are being retrieved from server.