>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.