FetchAll false and detail table
Posted: Tue 13 Nov 2007 10:20
Hi, I have this problem:
2 TMSQuery (v4.3) as master-detail, master table has about 500000 rows, when I set FetchRow on master table to false, then fetch of detail rows slows down. On true is fetch of detail very quick. Table with details contains about 1000000 rows and then I need fetch detail row only when I need them (not LocalMasterDetail). This problem is only when I run program from another pc, not pc where is SQL2005 server running. On the same pc is everything OK. When I set NonBlocking it works good, but I fetch every data from Master. Huge net traffic.
Thanks for yor suggestion.
Peca
2 TMSQuery (v4.3) as master-detail, master table has about 500000 rows, when I set FetchRow on master table to false, then fetch of detail rows slows down. On true is fetch of detail very quick. Table with details contains about 1000000 rows and then I need fetch detail row only when I need them (not LocalMasterDetail). This problem is only when I run program from another pc, not pc where is SQL2005 server running. On the same pc is everything OK. When I set NonBlocking it works good, but I fetch every data from Master. Huge net traffic.
Thanks for yor suggestion.
Peca