Hi Phil, I put in a work order with Sybase also. BUT, they gave me a link to the latest revision of 6.5.1 ftp://psaftp.sybase.com/pub/private/pbpatch/pb65_weekly/65112732.zip They told me that problem has not been addressed in this fix. Yet it seems to have fixed this problem, at least for me :-). I did not do the amount of testing that you have done, so it may not work for you. My problem was on the second import of 136,000 rows, PB would stop with an out of memory error on ~75,000 rows every time. HTH |---------------------------------------------------| Daniel Mullings MTSC - Systems Engineer GTE Data Services Irving, Texas [EMAIL PROTECTED] |---------------------------------------------------| -----Original Message----- From: Phil Fausz [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 24, 1999 7:50 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Memory Problems - UPDATE Sorry, no resolutions to the problem as of yet. We have been talking to Sybase and have a work order in. We sent them another app so they can test what's going on, but haven't heard from them. We have also stopped trying to fix the problem as the man hours already spent on this are crazy. I'll keep you informed if anything new happens. Happy Holidays! Phil >Hey Phil, >Any resolution to the problems below? > >I am experiencing the same problem!! > >Phil Fausz wrote: ><snip> >We're running into problems using datawindows and getting memory errors >when >the result set is greater than 100,000 rows. We've run several tests, here >are two: > >1) PC - p300, 256MB RAM, 1 GB virtual memory. Get error at 108,800. >2) PC - p400, 64MB RAM, 500 MB Virtual Memory. Error at 108,820. > >We did the same test with PB 5, 6, 6.5, and 6.5.1. We ran out of memory at >(approximate values): > >pb5 - 500,000 rows. >pb6 - 250,000 rows. >pb6.5 - 150,000 rows. >pb6.5.1- 108,000 rows. ><snip> > ><snip> >With PB.6.0 and higher, datawindows crash with 'Out of Memory' errors after >retrieving (or importing) as few as 145,000 rows. The amount of virtual >memory used at this point is fairly consistent with the levels for >PB.5.0.02 >after the same # of rows, with plenty of virtual memory still available! > ><no attachment> >The attached ZIP file contains a PBL with a single 'external' datawindow >object and a compatible tab-delimited dataset which can be imported into >the >datawindow. I limited the dataset size to 50,000 rows, but it's easy enough >to produce the errors by importing the file multiple times. Under releases >PB.6.5 and PB.6.5.1, expect to get an 'Out of Memory' error during the 3rd >import (between 100,000 and 150,000 rows) ! > >I had a little more luck with PB6.0, but eventually it died (around 430,000 >rows) with plenty of Virtual Memory still available! ><snip> > > >|---------------------------------------------------| >Daniel Mullings >MTSC - Systems Engineer >GTE Data Services >Irving, Texas >[EMAIL PROTECTED] >|---------------------------------------------------| > > ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com > [EMAIL PROTECTED] HOSTED BY IIGG, INC. FOR HELP WITH LIST SERVE COMMANDS, ADDRESS > A MESSAGE TO [EMAIL PROTECTED] WITH THE FOLLOWING MESSAGE: help pfcsig > SEND ALL OTHER INQUIRES TO [EMAIL PROTECTED]
