Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Ali Koumaiha
  Where is Ali Koumaiha?
 Farmington Hills
 Michigan - Lebanon
 Ali Koumaiha
 To: Mike Ayuso
  Where is Mike Ayuso?
 Belize City
 Belize
 Mike Ayuso
 Tags
Subject: RE: Pass through SQL
Thread ID: 395357 Message ID: 395409 # Views: 40 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Tuesday, January 14, 2014 6:35:57 PM         
   


> >
> >
> > Hi,
> > Whenever I develop a system with a remote backend server using MS SQL Server I
> > always pay close attention to my default start up SQL commands to populate
> > my local cursors.
> >
> > As examples. . .
> > - My normal local cursors in a POS system may only be populated with
> > invoice header and invoice detail record for the past 30 days.
> > - An autoshop program with scheduled tasks may only initially bring
> > in all jobs completed in the past 7 days, all uncompleted jobs and
> > all new jobs in the future.
> >
> > This like the above will greatly reduce the load time in minimizing the
> > initial record load upon application start up. This will also maintain
> > a even start up time as the database tables grow in sizes.
> >
> > You do need maintenance options to be able to look at other records not
> > including in your initial WHERE conditions, but this is easy to do and
> > I always scope the select statements with a main WHERE condition. That
> > is to say selecting aged records I may only allow the user to select
> > records between a staring and ending date range and an option for all
> > records against one customer only, etc.
> >
> > Pete "the IceMan", from the Great White North of Canada.
> > www.marathongriffincomputers.com
>
> Thanks. I will re-visit and see where this is possible in my example. However, I am still concern because the tables are extremely small at the moment since I am just starting with the implementation. Hence, currently it has nothing to do with how many records are fetched with my current WHEREs.

Can you have someone else test it from a different faster connection (at the client side?) if it is the same outcome, then, it is something i would assume from GoDaddy, or their outbound bandwidth is slow.

I am developping the same thing, except, I choose another host company (Reliable Servers) and they gave me 100MBps In/Out on the server.

I test my app with tons of data in it (I imported legacy data into my sql 2012) and it runs FAST!
beats the hell out of VFP dbfs and the data is remote.

I tested it with my crappy DSL at home, 10MBps down, 2 Mbps up.
tested it with my Phone internet as tethering (LTE, pretty fast internet)
tested it with Boingo hotspot at the airport (1Mpbs down/320Kbs up)
tested it with Fast Cable model.

All results were amazingly fast.

Mind you my server specs:
windows 2012 R2 server
MS SQL 2012 Standard
16GB RAM
100Mpbs In/Out at the Server

Front End:
Pure VFP 9 SP2
About 50+ tables.
Mostly Stored procedures

some tables (sales transactions and customer history records) 200k+ tables.

When you run the app, you almost think it is local.

I tested it from different client machines (Such as Windows 7, Windows xp, windows 8.1)
From machines with VFP installed on it.
with Machines just the VFP runtimes installed
etc..


Ez Logic

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