Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Ken Murphy
  Where is Ken Murphy?
 Springhill
 Canada
 Ken Murphy
 To: RSI Pvt. Ltd.
  Where is RSI Pvt. Ltd.?
 
 India
 RSI Pvt. Ltd.
 Tags
Subject: RE: Speed issue in multi-user environment
Thread ID: 78926 Message ID: 78969 # Views: 3 # Ratings: 0
Version: Visual FoxPro 8 Category: Grids
Date: Tuesday, October 11, 2005 5:11:08 PM         
   


> I have a form that runs on a table of 170,000 records approx. and is shared by many users. The form has grid displaying these data with filter option. When open by many users, the grid becomes very slow, filters are applied very very slow. How do I manage speed for this particular case. Can anyone help me?
>
> Thanks in advance.
>
> Mandeep Singh Ravesh
> +919899589180


Eric recommends parameterized views, but this may not be the fastest - you need to look at a variety of solutions and pick the one that is fastest for you.

This is another approach that you should experiment with. Try a seek/scan while loop. I use it in a situation where I have approximately 1,000,000 transaction records and I need to display the 60 or so records associated with a specific supporter. I have a "SupporterNo" index on Transactions.SupporterNo with a filter of "Transactions.Status" = 1 ("The transaction is not part of a payment that was "Deleted") In my form, I create a cursor (TempTx) that has fields that are identical to the fields in my transactions table and then,

ZAP IN 'TempTx'	&& Clear my grid cursor
SELECT Transactions
SET ORDER TO TAG SupporterNo
IF SEEK(lnSupporter) && Find the first transaction for this supporter
   SCAN WHILE Transactions.SupporterNo = lnSupporterNo
	&& INSERT INTO ... Add the record to my TempTx cursor
   ENDSCAN
ENDIF 

In my case, this was faster than a fully optimized query.

Ken

ENTIRE THREAD

Speed issue in multi-user environment Posted by Mandeep Ravesh @ 10/11/2005 8:43:19 AM
RE: Speed issue in multi-user environment Posted by Erik Gomez @ 10/11/2005 9:31:30 AM
RE: Speed issue in multi-user environment Posted by Andy Kramek @ 10/11/2005 1:28:45 PM
RE: Speed issue in multi-user environment Posted by Ken Murphy @ 10/11/2005 5:11:08 PM