Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: tushar Kanvinde
  Where is tushar Kanvinde?
 Kolhapur, Maharastra
 India
 tushar Kanvinde
 To: Luca Moioli
  Where is Luca Moioli?
 Venezia
 Italy
 Luca Moioli
 Tags
Subject: RE: Rushmore for SCAN
Thread ID: 345230 Message ID: 345236 # Views: 80 # Ratings: 1
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Monday, May 21, 2012 8:56:21 AM         
   


> Dear friends,
> I have a typical SCAN used many times in application:
>
>
> SELECT Table1
> SCAN ALL FOR Field1=m.Val1 AND ALLTRIM(Field2)==m.Val2
> 

>
> I have SET EXACT OFF and I would like optimize at best performaces with Rushmore.
> Table1 is indexes on DELETED(), Field1 and Field2.
>
> Is this the best condition for optimization?
> Should Field2 be indexed on ALLTRIM(Field2)?
> I have always avoided functions in indexes like
>
>
> INDEX ON ALLTRIM(Field2)
> 

>
> because I fear they slow performaces.
> Thank you very much

If values in your field2 do not start with spaces,do not use ALLTRIM

m.Val2=PADR(m.Val2,len(Field2))
SCAN ALL FOR Field1=m.Val1 AND Field2==m.Val2



Regards
Tushar
http://weblogs.foxite.com/tushar/

ENTIRE THREAD

Rushmore for SCAN Posted by Luca Moioli @ 5/21/2012 7:46:07 AM
RE: Rushmore for SCAN Posted by mk sharma @ 5/21/2012 7:55:07 AM
RE: Rushmore for SCAN Posted by tushar @ 5/21/2012 8:56:21 AM
RE: Rushmore for SCAN Posted by Chuanbing Chen @ 5/22/2012 12:47:40 AM
RE: Rushmore for SCAN Posted by Simon Cropper @ 5/23/2012 3:16:40 AM
RE: Rushmore for SCAN Posted by Luca Moioli @ 5/23/2012 7:06:58 AM
RE: Rushmore for SCAN Posted by mk sharma @ 5/23/2012 7:27:19 AM
RE: Rushmore for SCAN Posted by Luca Moioli @ 5/23/2012 9:30:59 AM
RE: Rushmore for SCAN Posted by mk sharma @ 5/23/2012 9:35:40 AM