Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP8 Wish - a server-like component
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00558803
Message ID:
00564879
Views:
25
>Bob, you work at the wrong place.
>
>Since I had the idea anyhow, in the next few months I will do the following :

Hey, wanna see a demo of my VFPSQL - Server platform. I wrote it this morning before I woke up. - sorry no com - no .NET, no SOAP just sql odbc.

Impressive results. 1,5 mil records, searched in .00036 seconds. for a result set of 1500. and thats without an index. !!

Here is the commands
m_start = seconds()
set session to remote 'myremote.ini'
set database to mybigdatabase
use mylargetable in 0
select * from mylargetable for acnum = '156554' into cursor rw mylocalcursor.
select mylocalcursor
m_end = seconds()
m_time = m_end=m_start
? reccount()
? m_time

***Then I woke up.

Bob Lee
In the beginning, there was a command prompt, and all was well.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform