Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Increase SQL speed?
Message
From
04/05/2005 17:04:03
Christian Ehlscheid
Edv Ermtraud Gmbh
Rengsdorf, Germany
 
 
To
04/05/2005 12:00:12
Tom Bellmer
Kansas, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: Increase SQL speed?
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows 2000 SP4
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01010813
Message ID:
01011070
Views:
17
Hello,

stating the eventual problem with the FILE function
what you can do is:
ADIR(laFiles,'yourDirectory\*.svg') and
then use ASCAN() instead of FILE() in the SQL command .. should speed it up considerably ..

Regards
Christian
Previous
Reply
Map
View

Click here to load this message in the networking platform