Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Fetching data
Message
From
24/01/2002 21:42:15
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Fetching data
Miscellaneous
Thread ID:
00610258
Message ID:
00610258
Views:
35
Hi everyone,

I'm trasfering my under DOS program (using Clipper) into under windows program
using visual foxpro),it all went just fine until I found that fetching data
using Visual Foxpro (46 seconds) took longer than using Clipper (2 seconds), the table fetched (master table) consist of around ten thousand records.
I put the result of fetching data into a cursor whereas in Clipper I put it in an array.

Here is the code that I use :

sele master table
seek ...
do whil ..
...
another table1
seek ...
if..
endi
...
table2
seek ...
if..
endi
...
table3
seek ...
if..
endi
...
insert into tmpCursor ...
sele master table
skip
endd

I put the program in the network.
I wonder if there is something wrong in my code.


TIA,

Budianto
Next
Reply
Map
View

Click here to load this message in the networking platform