Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Will this expression use Rushmore?
Message
 
 
To
28/01/2003 13:18:24
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00746321
Message ID:
00746355
Views:
20
I don't know, but you could convert it to a SQL and use SYS(3054, 1) function to show the level of optimization.

select * from mytable where ;
eval(lcalias + '.' + lcForeignKeyName) = uPrimaryKeyValueToLookUp

>I have a data access class with the following line of code:
>
>locate for eval(lcalias + '.' + lcForeignKeyName) = uPrimaryKeyValueToLookUp
>
>lcAlias is 'p1', lcForeignkeyName is 'stock_id'
>there is an index on stock_id (alone)
>
>There are 14K rows in the table. Sometimes this locate executes in an instant, and other times takes 7 or 8 seconds. I don't understand why it won't always use Rushmore/find the record immediately, and I have yet to determine what is different in the case where it doesn't execute in an instant.
>
>Does the eval() play any role/hinder Rushmore ?
>
>TIA
Mark McCasland
Midlothian, TX USA
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform