Leemi
Mon Sep 20 10:27:54 CDT 2004
Hi Shahriar:
Have you optimized Visual FoxPro internal use of memory with the SYS(3050)
function? See
176483 PRB: Large Amounts of RAM Seem to Process Data Slowly
http://support.microsoft.com/?id=176483
Are you using the most recent version of the VFP ODBC driver?
277772 INFO: Visual FoxPro ODBC Driver Not Included in MDAC 2.6 and Later
http://support.microsoft.com/?id=277772
Do you have "Fetch data in background" option unchecked in the DSN for the
VFP driver?
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
>I have a SQL table with about 40,000 records and I have created a Foxpro
>view. Deleting records is too slow !!!
>delete from test1 where fy="2000"
>or delete all for fy='2000'
>This used to take couple of seconds in foxpro and now about couple of
>minutes in SQL. Any suggestion on speeding this up?
>Thanks
>Shahriar