Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Xbase commands Vrs Sql commands
Message
From
11/05/2005 03:24:57
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
11/05/2005 02:54:38
Suhas Hegde
Dental Surgeon
Sirsi, India
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 6 SP5
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01011885
Message ID:
01012730
Views:
17
>hi Cetin,
>
>May be I found the curlprit.
>
>My laptop AMD athlon 1400 has a damn slow hd(dont know i/o or seek time) with 128 mb ram and XP home. When ever i run the sql queirs the hd lights up and takes many secs to turn off and untill then the system is unresponsive or very slow . even switching between the applications is slow. May be i was misled by that .
>
>I have found that the sql causes that behivariour and not Xbase.
>
>suhashegde

Suhas,
I don't know of original problem. I simply got the question as "is xBase always faster". There are places where xBase prefarable over SQL but there are places for just the reverse.
With SQL HDD lights going on and staying like that + unresponsive after sometime suggests it's doing a lot of disk swap and system resources are low (and VFP wise SQL might be something not optimized - ie: an unintentional full join instead of inner).
Do you have a specific SQL or xBAse code causing headache?
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform