General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only