Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can this SQL run faster
Message
 
To
14/04/2005 12:32:06
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01004644
Message ID:
01004740
Views:
28
Thanks, that is interesting.

Here is a very simple test code:
>
>
>Rand(-1)
>Create Cursor test1 (Id i)
>Create Cursor test2 (Id i, f1 c(1))
>
>For ix=1 To 10
>  Insert Into test1 Values (m.ix)
>  For jx=1 To 5
>    Insert Into test2 Values (m.ix,Chr(Asc('A')+Rand()*26))
>  Endfor
>Endfor
>
>lnCalled = 0
>Select * from test1 ;
>  where id in (select id from test2 where f1 == "H" and HowManyTimes())
>? m.lnCalled
>
>Function HowManyTimes
>lnCalled = m.lnCalled + 1
>
Cetin
Previous
Reply
Map
View

Click here to load this message in the networking platform