Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Tom Saddul
  Where is Tom Saddul?
 Paranaque
 Philippines
 Tom Saddul
 To: Mike Ayuso
  Where is Mike Ayuso?
 Belize City
 Belize
 Mike Ayuso
 Tags
Subject: RE: Pass through SQL
Thread ID: 395357 Message ID: 395453 # Views: 37 # Ratings: 1
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Wednesday, January 15, 2014 4:43:47 AM         
   


> 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

Just note the difference between 1MB busy internet versus 100MB not so busy LAN. If you really want to use the internet as your application network client/server style, at least you should have a dedicated line. A public 1MB internet is simply not enough since your speed can go down to zero.

http://www.digisoftph.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