Thanks. Not trying to push it to the screen. But to create an array that cycles through and processes files to disk.
On 9/15/04 8:02 PM, "Robert Shubert" <[EMAIL PROTECTED]> wrote: > Roland, > > Technically speaking, the Witango server will only limit an execution by > memory size and querytimeout. > > I would be hard pressed to display 100,000 records of information on one > screen, even 20,000 would be tough, but if you really have to, try to do > as little work in Witango as possible, push as much effort to your > database as you can, at least for creating the final dataset. Don't use > variables other than request. You might tie up you server, but it should > work endlessly on as many records as you can select. > > Robert > > -----Original Message----- > From: Roland Dumas [mailto:[EMAIL PROTECTED] > Sent: Wednesday, September 15, 2004 6:03 PM > To: [EMAIL PROTECTED] > Subject: Re: Witango-Talk: Practical max size for arrays > > Any ideas? > I once did a biggun on T2K on MacOS 8. It started to crap out between 10 > and > 20 thousand rows. Maybe that was T2K or MacOS. I'm considering grabbing > from > a database that could easily grow to 100K records, but resultsets might > be > 10-20K records. It would not manipulate the array, but cycle through > once to > make some decisions and an output for each row. > > Am I nuts? > > > On 9/15/04 11:27 AM, "Roland Dumas" <[EMAIL PROTECTED]> wrote: > >> What's the practical largest size for arrays? Max rows? >> 1K rows? 5K? 100K? (ok, I know that one doesn't work) >> >> Trying to figure out at what point arrays are not as fast as creating > a temp >> table and running queries against it. >> >> > > > ________________________________________________________________________ > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf > > ________________________________________________________________________ > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf > ----------------------------------------- Roland Dumas Roberts Information Services 310 W. Bellevue Avenue San Mateo CA 94402 650-347-1373 415-412-9300 (cell) [EMAIL PROTECTED] SMS: http://new.servqual.com/html/sms.tml ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
