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?
Enlarge FetchRows Maximum limit
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.
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.