Three main layers nested table in the main table ClientDataSet.CommandText: = 'Select * from MasterTable', ClinetDataSet.Active: = true where the data transferred to a number of the main table,

Category: Delphi -> Database Author: helfred Date: 2011-11-19 18:05:57
 
helfred
2011-11-19 18:05:57
Three main layers nested table in the main table ClientDataSet.CommandText: = 'Select * from MasterTable', ClinetDataSet.Active: = true in the main table of data transferred to a group and found that it transferred to the speed very slow, tracking found that he put all the data is transferred from the table over there a way to let him tune it a little faster.
tracking is the following contents:
exec sp_executesql N'select * from VW_StockDet where SysBillNO = @ P1 Order by SysBillNO, SN ', N '@ P1 char (20)', '200407260133 '
go
exec sp_executesql N'select * from VW_StockDet where SysBillNO = @ P1 Order by SysBillNO, SN ', N' @ P1 char (20) ', '200407260132 ; '
go
exec sp_executesql N'select * from VW_StockDet where SysBillNO = @ P1 Order by SysBillNO, SN ', N' @ P1 char (20) ', '200407260131'
go
exec sp_executesql N ' select * from VW_StockDet where SysBillNO = @ P1 Order by SysBillNO, SN ', N' @ P1 char (20) ', '200407260130 ; '
.........
j568083903j
2011-11-19 18:15:21
PacketRecords = 10;
xuleitools
2011-11-19 18:26:42

ClientDataSet's PacketRecords = 10; added to 0 will automatically paged it.

getNextRecord then wait until the next packet
zyd329761013
2011-11-19 18:40:45
said above makes sense, not all at once into the herd can