Hi Mike,

First, try using a parameterized view and see the difference. Better yet, try this (are you listening Ed?):

If you don't have one already, create a table with one million records with an integer primary key and some text fields (create indexes on the parameterized fields) and fill the fields with data. Then create a p-view which will return as many records as you want. Set the parameter(s) and REQUERY() to fill a grid.

Then try the above with xBase and get back to me with your findings.

Second, and most important, is that it's easy for many of us to rely on xBase at the expense not learning how to effectively use SQL. As a result, many of us would be hard pressed to develop a C/S application should the opportunity presents itself. This is the point I'm trying to make. Being well disciplined in SQL allows you to create C/S and non-C/S apps with VFP, but not both.

Having a background in xBase gives us an advantage over other developers in that we know data. But we can't rest on our laurels, we have to go the extra mile or become another fart in the wind.



>Hi Jeff,
>
>You're confident, I'll give you that. But why can't you use seek()? I have a table with 100,000 records, an integer field that basically equals the record number, and an index on that field. When I do:
>
>clear
>go top
>
>*Find early record using SQL
>ns = seconds()
>select number from sqlspeed where number = 1 into cursor temp
>?seconds() -ns
>USE
>SELECT 1
>goto top
>
>*Find early record using SEEK()
>ns = seconds()
>=seek(1, 'sqlspeed', 'number')
>?seconds() - ns
>goto top
>
>*Find late record using SQL
>ns = seconds()
>select number from sqlspeed where number = 99999 into cursor temp
>?seconds() -ns
>USE
>SELECT 1
>goto top
>
>*Find early record using SEEK()
>ns = seconds()
>=seek(99999, 'sqlspeed', 'number')
>?seconds() - ns
>goto top
>
>and after about 20 times, I notice a trend in the output kindof looks like:
>
>0.035
>0.001
>0.006
>0.000
>
>I don't think your answer to Ed's question is very complete (Lol!), are you avoiding it?