Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Pratik Singh
  Where is Pratik Singh?
 Kota
 India
 Pratik Singh
 Tags
Subject: SLOW WORKING ON LAN
Thread ID: 365586 Message ID: 365586 # Views: 64 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Forms
Date: Friday, December 28, 2012 10:36:57 AM         
   


Hi xperts

Now i have facing problem in my app on networking. when i run application on single machine its working good and speed is also good. but when i use same app on another machine parrell works both at same time on local network . application goes slow it takes much time to open a form and other working.

for examlpe
i have to open form SUPPLIER. it has multi tables relation with each other and some table on buffer mode and also some table filtered.
when i select an account on single machine it works very fast but when i use 2 or 3 machine parrell it works much slow it takes time for data retrieve.

LIKE: i have use simple query on form button : SELECT MAX(BDATE) AS DATE FROM VENDOR INTO CURSOR _CHECK

it works fast when use single pc, but its takes much time when use same form some other machines at same time.

1.i also use index on bdate field on vendor table
2.vendor table buffered and filtered

please guide me where is mistake or how i much easier to operate.

Regards

Prakit



Learning never ends

ENTIRE THREAD

SLOW WORKING ON LAN Posted by Pratik Singh @ 12/28/2012 10:36:57 AM
RE: SLOW WORKING ON LAN Posted by Pete Sass @ 12/28/2012 11:42:17 AM
RE: SLOW WORKING ON LAN Posted by Pratik Singh @ 12/28/2012 1:18:20 PM
RE: SLOW WORKING ON LAN Posted by Pete Sass @ 12/28/2012 2:33:05 PM
RE: SLOW WORKING ON LAN Posted by Pratik Singh @ 12/28/2012 5:56:09 PM
RE: SLOW WORKING ON LAN Posted by David Mustakim @ 12/28/2012 6:07:19 PM