The return of data speed is always a volume concept. If you select * and there are 40-100 columns and you really only need 20 only ask for them back. Your speed will improve for quantities > 1000 rows.
On Thu, Mar 29, 2018 at 4:13 PM, Paul H. Tarver <[email protected]> wrote: > I was just about to post a follow up note for the group because once I > started testing with changing the default PacketSize, I realized that it > wasn't changing no matter what I did. > > In response to your comments regarding optimizing the queries, I think I > should clarify that what I'm interested in speeding is up isn't the query > itself, but rather the transfer of data from the server to my local > instance > of VFP. I am under the impression I will get a bit of a boost once I move > my > development off the VPN to a full internal network connection, but I guess > I'm greedy enough to think perhaps I can squeeze just a few more > milliseconds out of the data transfer process since with 30 separate > databases to query the transfer time is taking up a significant portion of > my total processing time. > > The Fox has never let me down, so I just figured I would go back to the > well > one more time! :) > > Paul > > > -----Original Message----- > From: ProfoxTech [mailto:[email protected]] On Behalf Of > Richard > Kaye > Sent: Thursday, March 29, 2018 2:36 PM > To: [email protected] > Subject: RE: Tuning VFP SQL Pass-Through For Fastest Times Transferring > Query Results > > I was trying to play with packet size recently and it appears that the > current versions of the SQL ODBC driver have deprecated this parameter. At > least my attempts to change were met with failure. > > I think the best opportunity for optimization would be to create your > queries as stored procedures and then call the stored procs. This will > allow > SQL to generate execution plans that can be reused. This also assumes your > queries are written in a way that allows you to pass parameters to the SPs. > > -- > > rk > > -----Original Message----- > From: ProfoxTech <[email protected]> On Behalf Of Paul H. > Tarver > Sent: Thursday, March 29, 2018 2:58 PM > To: [email protected] > Subject: Tuning VFP SQL Pass-Through For Fastest Times Transferring Query > Results > > I'm working on a project which involves issuing multiple queries across > several SQL databases and servers. At this point, I'm polling about 30 > databases and retrieving data from four tables from each database. > > > > I really have no reason to complain as my procedure including retrieving > the > data synchronously over a VPN, processing results locally and then > exporting > the data to local files only takes about 6 minutes. > > > > However, I see this as an opportunity to tune my sql back-end connection > and > was wondering if anyone had any suggestions say for setting the PacketSize > or other changes that might optimize the retrieval of data from the > server(s). > > > > Thanks in advance! > > > > Paul > > > > > > --- StripMime Report -- processed MIME parts --- multipart/alternative > text/plain (text body -- kept) > text/html > --- > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/cajidmy+5y+kwsnsbf5zq1esrggn2_eakbpdhntb-dhhsn-e...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
