VFP8?
Edward Gioja
contained free newsgroups...so I've been out of the loop. I hope I'm not
pushing any buttons, but VFP8? The last I heard was that 6 was going to be
the last release, and MS was going to drop the product line.
In many ways unfortnate, our data has really outgrown the file size
limitations imposed by the Windows Architetcure, so it's being moved to
INFORMIX and LINUX. I still do alot of work with VFP, utilizing ODBC
connections to the main data because I still think it is the best tool for
the desktop database. Frankly, you can't beat Rushmore Optimization, and
the price is reasonable.
Which leads me to a question -
1) Are there any tips and tricks to be shared to ensure optimal ODBC SQL
speeds across these platforms? Also, satelite offices and traveling
employees utilize VPN. Some of our queries can be quite slow. I'm certain
that some of the same rules apply (ie. ensure that the query statement
matches an existing index expression).
2) Is there a way to keep ODBC SQLs from "locking up" the rest of the
computer?
Rick Bean
It's "worse" - VFP 9.0 is scheduled for release later this year! For a free beta copy go to http://www.microsoft.com/downloads/details.aspx?familyid=23fbc57b-93b0-4cb7-b376-53ca04fca159&displaylang=en. You can read about all the new things coming in VFP 9.0 in the VFP Newsletters starting at http://msdn.microsoft.com/vfoxpro/letters/. Don't forget to follow the archive links for even more info on 9.0.
Consider using ADO rather than ODBC - especially for updates - it's faster. Since the queries happen on the files server in a client-server environment, check you server resources to speed them up. Make sure you don't ask for more records and fields than you really need.
Rick
"Edward Gioja" <EdG...@comcast.net> wrote in message news:HfmdnT0BzJD...@comcast.com...
Cindy Winegarden
In addition to what Rick said...
Microsoft's free news server is msnews.microsoft.com. No need to go through
another news server (free or not).
--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy.wi...@mvps.org www.cindywinegarden.com
"Edward Gioja" <EdG...@comcast.net> wrote in message
news:HfmdnT0BzJD...@comcast.com...
> I've had my head down for awhile, and just recently got an account that
> contained free newsgroups...so I've been out of the loop. ....
Olaf Doschke
> another news server (free or not).
what is configured in my Newsreader...
And there are much more frequented groups than xplat:
Make a search on groups starting with
microsoft.public.fox.
and there are some newsgroups in other languages
several
microsoft.public.es...,
microsoft.public.fr.fox,
microsoft.public.de.fox
and further...
Bye, Olaf.
Lee Mitchell
If you decide to use the VFP ODBC driver to access the data, you need to
optimize your queries for best performance. Here is an article that talks
about general suggestions for optimizing queries:
248608 INFO: SQL SELECT Optimization Levels and Performance
http://support.microsoft.com/?id=248608
Note: you need the development version of VFP to use the SYS(3054)
function.
I hope this helps.
This posting is provided "AS IS" with no warranties, and confers no rights.
Sincerely,
Microsoft FoxPro Technical Support
Lee Mitchell
*-- VFP9 Public Beta Now Available!! --*
Download the VFP9 beta here: http://msdn.microsoft.com/vfoxpro/
*-- VFP8 HAS ARRIVED!! --*
Read about all the new features of VFP8 here:
http://www.universalthread.com/VisualFoxPro/News/VFP8Release.asp
Purchase VFP8 here:
http://shop.microsoft.com/Referral/Productinfo.asp?siteID=11518
Keep an eye on the product lifecycle for Visual FoxPro here:
http://support.microsoft.com/default.aspx?id=fh;[ln];lifeprodv
- VFP5 Mainstream Support retired June 30th, 2003
- VFP6 Mainstream Support retired Sept. 30th, 2003
>Edward,
>It's "worse" - VFP 9.0 is scheduled for release later this year! For a
free beta copy go to
>http://www.microsoft.com/downloads/details.aspx?familyid=23fbc57b-93b0-4cb7
-b376->53ca04fca159&displaylang=en. You can read about all the new things
coming in VFP 9.0 in the >VFP Newsletters starting at
http://msdn.microsoft.com/vfoxpro/letters/. Don't forget to follow the
>archive links for even more info on 9.0.
>Consider using ADO rather than ODBC - especially for updates - it's
faster. Since the queries >happen on the files server in a client-server
environment, check you server resources to speed >them up. Make sure you
don't ask for more records and fields than you really need.
>Rick
>"Edward Gioja" <EdG...@comcast.net> wrote in message
news:HfmdnT0BzJDZcIbcRVn->h...@comcast.com...