Page 1 of 1

Enlarge FetchRows Maximum limit

Posted: Fri 03 Sep 2010 06:00
by easyblue
Hello

Current FetchRows value can not exceed 10000.

Is it possible to enlarge this value?

My case is that server is strong enough, network is fast enough, and database is big enough, user is many enough.

Many user is connected at the same time, although server is very strong, I prefer to fetch as many data as possible, and the limitation is my local client processing capability not the remote server.

Is it possible to break this limitation on FetchRows?

Posted: Fri 03 Sep 2010 07:45
by Dimon
To solve the problem set the FetchAll property to True to fetch all records on table opening.

Posted: Fri 03 Sep 2010 13:02
by easyblue
Hello

Set FetchAll is not feasible.

The server is a very powerful giant. Database is big enough that have over millions of records. Set FetchAll to True will definitely crash my client.

one record is of size 4k, by current FetchRows limit, I can fetch 40M per fetch. But since the client machine have 4G RAM, I would like to fetch as much as possible data by one fetch for very complicated calculation at client side.

Is it possible to cancel this hard limit? Or at least enlarge it by 10 times bigger, since now the memory is quite cheap.

Posted: Mon 06 Sep 2010 08:13
by Dimon
Ok, we will remove this limitation in the next MyDAC build.