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
 To: Pete Sass
  Where is Pete Sass?
 Marathon, Ontario
 Canada
 Pete Sass
 Tags
Subject: RE: SLOW WORKING ON LAN
Thread ID: 365586 Message ID: 365614 # Views: 39 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Forms
Date: Friday, December 28, 2012 5:56:09 PM         
   


> Hi,h
>
> Yes you can use the TOP 1 with ORDER BY ASC/DESC to get the highest and lowest values out of a table.
> You of course can use the the MAX() AND MIN() functions here.
> One of the major differences is that the SELECT..TOP 1 will only ever return one record.
> Where as joining against the max has a possibility of returning more than one record.
>
> So tell us how you make out with your speed issues?
>
> Pete "the IceMan", from the Great White North of Canada.
> www.marathongriffincomputers.com
> Home of the Canadian and US download for Chen's VFP C++ Compiler
> http://www.marathongriffincomputers.com/VFP-C++-Compiler.html


Hi
the speed issue is on multiuser environment. because when I use this on single machine it works fast return but on multiuser
environment when some other user operate same form then gives much late result. aprox. 40 to 45 seconds.

that is my question. if vfp native database shared on multiuser. is that possible to work slow vary to machine to machine ?

why same code take different time on single or multi machines. it take 5/45 seconds.



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