Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Ravi Taxali
  Where is Ravi Taxali?
 Markham
 Canada
 Ravi Taxali
 To: Mayur Subbu
  Where is Mayur Subbu?
 Bangalore
 India
 Mayur Subbu
 Tags
Subject: RE: Join query slow
Thread ID: 228755 Message ID: 228909 # Views: 2 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: General VFP Topics
Date: Friday, May 22, 2009 4:16:01 PM         
   


> >
> > Use SYS(3054,1) before running your query and see what index tags VFP is using, if any. This may give you clues to take additional steps to further optimise your query.
> >
> > - Ravi Taxali
> > Visual FoxPro Made Simple -- An excellent book for beginners as well as experienced programmers
>
> Hello Mr Taxali,
>
> I just purchased the VFP book that u have authored. Wish u could dwell upon the reporting features more as this feature has received the max facelift.
>
> As regarding my query, though both tables are indexed on expression used in the Join condition, Sys(3054, 1) report no optimisation on both tables.
>
> Any suggestions.
>
> Thanx

Hello Mayur,

Thanks for purchasing my book. I hope you would find it useful.

If you see that the optimization is None, you may not have proper index tags or your query does not contain the WHERE clause. As mentioned by Anders,try SYS(3054,11) to get the complete optomization information including that for JOIN ON as well as WHERE. Please ensure that you have index tags on the mtrno field for both AOG and AOGMaster tables. Also ensure that you are using the Machine collate sequence for your index tags. (Use MODIFY STRUCTURE and have a look at the Index tab.) To be on the safe side, you may recreate the index tags with the following commands:

SELECT 0
USE aog EXCL 
INDEX ON mtrno TAG MTRNO COLLATE 'MACHINE'
USE IN AOG 
USE  AOGMaster EXCL 
INDEX ON mtrno TAG MTRNO COLLATE 'MACHINE'
USE IN AOGMaster 



Also, VFP may be able to use the INDEX tags only if the expressions used in the WHERE or JOIN ON clause exactly match the expression used in the INDEX expression(s).

- Ravi Taxali
Visual FoxPro Made Simple -- An excellent book for beginners as well as experienced programmers

ENTIRE THREAD

Join query slow Posted by Mayur Subbu @ 5/21/2009 10:55:59 AM
RE: Join query slow Posted by Ammar Hadi @ 5/21/2009 11:29:59 AM
RE: Join query slow Posted by Mayur Subbu @ 5/21/2009 3:59:01 PM
RE: Join query slow Posted by Anders Altberg @ 5/21/2009 4:20:19 PM
RE: Join query slow Posted by Anders Altberg @ 5/21/2009 4:32:29 PM
RE: Join query slow Posted by Anders Altberg @ 5/21/2009 11:33:42 AM
RE: Join query slow Posted by Mayur Subbu @ 5/21/2009 4:22:23 PM
RE: Join query slow Posted by Anders Altberg @ 5/21/2009 4:43:36 PM
RE: Join query slow Posted by Mayur Subbu @ 5/22/2009 4:01:56 AM
RE: Join query slow Posted by tushar @ 5/22/2009 7:59:31 AM
RE: Join query slow Posted by Anders Altberg @ 5/22/2009 11:54:02 AM
RE: Join query slow Posted by tushar @ 5/22/2009 12:17:35 PM
RE: Join query slow Posted by Anders Altberg @ 5/22/2009 9:31:24 PM
RE: Join query slow Posted by tushar @ 5/23/2009 6:56:11 AM
RE: Join query slow Posted by tushar @ 5/22/2009 12:30:31 PM
RE: Join query slow Posted by Anders Altberg @ 5/22/2009 2:24:11 PM
RE: Join query slow Posted by tushar @ 5/22/2009 4:14:42 PM
RE: Join query slow Posted by Mayur Subbu @ 5/22/2009 4:55:53 PM
RE: Join query slow Posted by Anders Altberg @ 5/22/2009 8:47:14 PM
RE: Join query slow Posted by Mayur Subbu @ 5/27/2009 4:44:53 AM
RE: Join query slow Posted by Anders Altberg @ 5/27/2009 8:10:28 AM
RE: Join query slow Posted by Anders Altberg @ 5/22/2009 11:35:39 AM
RE: Join query slow Posted by Mayur Subbu @ 5/22/2009 4:48:42 PM
RE: Join query slow Posted by Anders Altberg @ 5/22/2009 9:15:37 PM
RE: Join query slow Posted by Ravi Taxali @ 5/21/2009 4:07:12 PM
RE: Join query slow Posted by Mayur Subbu @ 5/21/2009 4:46:16 PM
RE: Join query slow Posted by Ravi Taxali @ 5/22/2009 4:16:01 PM