Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Pete Sass
  Where is Pete Sass?
 Marathon, Ontario
 Canada
 Pete Sass
 To: Mike Ayuso
  Where is Mike Ayuso?
 Belize City
 Belize
 Mike Ayuso
 Tags
Subject: RE: Pass through SQL
Thread ID: 395357 Message ID: 395389 # Views: 62 # Ratings: 2
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Tuesday, January 14, 2014 3:39:02 PM         
   


> I completed developing an application without using DBF tables. All my data is stored on Godaddy website service using MySQL database where I created all my tables. This has been working fine during my development. However, I am not sure if this is normal or I am really pushing my luck. My client is complaining that my application is very slow.
>
> I have proper indexes and my SQL statements are lean enough. Once the SQL is run and get my results, the rest of the function runs quick since the data is now on a local cursor as expected and is normal. However, every time my app runs an SQL statement to get data it is slow. My concern is if there is a better way or there is not much I can do. The internet speed where I live is an average of 1MB download and 512MB upload using a DSL line and without anybody utilizing it. Obviously, if more people are utilizing the internet link, the slower my application will be. However, eliminating my internet speed usage, is there anything else I should be concern about?
>
> Many thanks.
> Mike


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

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