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:
00564886
Views:
33
>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

:) I was going to call you for sharing the code! :)

...Y soy feliz, bien feliz, asi lo grito;
Mira, que el mundo sepa, que se sepa:
Soy feliz....                       

...And I'm happy, quite happy, so do I yell it;
Look, so the world knows it, so be known:
I'm happy...
 

Ismael Rivera "Oye cosita linda"
Previous
Reply
Map
View

Click here to load this message in the networking platform