Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: David Mustakim
  Where is David Mustakim?
 Jakarta
 Indonesia
 David Mustakim
 To: Mike Ayuso
  Where is Mike Ayuso?
 Belize City
 Belize
 Mike Ayuso
 Tags
Subject: RE: Pass through SQL
Thread ID: 395357 Message ID: 395405 # Views: 47 # Ratings: 1
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Tuesday, January 14, 2014 6:09:12 PM         
   


> >
> >
> > Concern ? Not much. Just ALL the consequences of putting your data away instead of in-house. If there is a good reason for doing it (which you did not explain) then it is just a matter of comparing "costs and benefits". Otherwise, simply DO NOT DO IT. Speed is NOT the only issue in having data not in-house.
> >
> > Regards,
> > David
>
> There are two reasons. 1 The application is also installed on laptops when traveling and need to access the application. 2. A different developer will be reading the data on a website in the very near future.


At least implement paging when you select records to display in grid and always pull just select fields that are really necessary and use LIMIT clause or TOP n... Even better if you can just display per record or really minimum selected few as Pete suggested

.

ENTIRE THREAD

Pass through SQL Posted by Mike Ayuso @ 1/13/2014 10:11:08 PM
RE: Pass through SQL Posted by anand kulkarni @ 1/14/2014 3:41:10 AM
RE: Pass through SQL Posted by Mike Ayuso @ 1/14/2014 5:53:52 PM
RE: Pass through SQL Posted by David Mustakim @ 1/14/2014 5:14:56 AM
RE: Pass through SQL Posted by Mike Ayuso @ 1/14/2014 5:52:38 PM
RE: Pass through SQL Posted by David Mustakim @ 1/14/2014 6:09:12 PM
RE: Pass through SQL Posted by Mike Ayuso @ 1/14/2014 11:57:33 PM
RE: Pass through SQL Posted by David Mustakim @ 1/15/2014 4:03:20 AM
RE: Pass through SQL Posted by Mike Ayuso @ 1/15/2014 4:37:50 PM
RE: Pass through SQL Posted by David Mustakim @ 1/15/2014 4:50:46 PM
RE: Pass through SQL Posted by Mike Ayuso @ 1/15/2014 5:19:05 PM
RE: Pass through SQL Posted by David Mustakim @ 1/15/2014 5:28:10 PM
RE: Pass through SQL Posted by Mike Ayuso @ 1/15/2014 5:51:41 PM
RE: Pass through SQL Posted by Pete Sass @ 1/14/2014 3:39:02 PM
RE: Pass through SQL Posted by Mike Ayuso @ 1/14/2014 5:57:06 PM
RE: Pass through SQL Posted by Ali Koumaiha @ 1/14/2014 6:35:57 PM
RE: Pass through SQL Posted by Pete Sass @ 1/14/2014 6:58:23 PM
RE: Pass through SQL Posted by Ali Koumaiha @ 1/14/2014 7:07:08 PM
RE: Pass through SQL Posted by Tom Saddul @ 1/15/2014 4:43:47 AM
RE: Pass through SQL Posted by Mike Ayuso @ 1/15/2014 4:46:26 PM