Print Thread
problem with ToracleDataset
#784 08/19/00 09:39 PM
Joined: Aug 2000
Posts: 2
Seville-Spain
M
mfdez Offline OP
Member
OP Offline
Member
M
Joined: Aug 2000
Posts: 2
Seville-Spain
I have an Application, my first Application
with DOA & Delphi 5.0, and when I try to open
the TwwOracleDataSet is very slow (10 seconds) to open the Table. Whe i Begin to design the Application are very fast because
there is few records.

Someone knows what happend?

In ADO there is one property to fetch a few records and the rest fetchs on background.

Re: problem with ToracleDataset
#785 08/21/00 02:07 PM
Joined: Aug 1999
Posts: 22,206
Member
Offline
Member
Joined: Aug 1999
Posts: 22,206
The TOracleDataSet has a QueryAllRecords property. When you set it to False, only the visible records will initially be queried. The default value of this property is True, because we assume that you are always interested in the complete result set. If this is not the case, you should probably modify the where clause of your query.

------------------
Marco Kalter
Allround Automations


Marco Kalter
Allround Automations

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.116s Queries: 14 (0.075s) Memory: 2.4959 MB (Peak: 3.0393 MB) Data Comp: Off Server Time: 2024-04-30 22:50:50 UTC
Valid HTML 5 and Valid CSS