Performance Problem with large file

simplsol at aol.com simplsol at aol.com
Thu Feb 22 11:29:22 CST 2007


Len,
If it is taking 3 seconds now, processing from a variable should take 
(far) less than one second. If that is so, then you will not need to 
worry about covering the "hole".
I do second Richard's suggestion about moving from XML; it is really 
slow, takes more memory for code, takes more memory for data, etc. - 
worth asking the vendor if it is necessary.
Also, are you using "repeat with" where you could be using "repeat 
for"? The latter is about ten times faster.
Paul Looney

-----Original Message-----
From: len-morgan at crcom.net
To: use-revolution at lists.runrev.com
Sent: Thu, 22 Feb 2007 9:05 AM
Subject: Re: Performance Problem with large file

   Len Morgan wrote: 
 
 > > ...the problem is that I'm displaying the file in a rather large 
 > > text field as it is being built up. Each line of the CSV file 
 > > generates about 40 lines of XML. 
 >  
 >That's one reason I rarely bother with XML. :)  
  Unfortunately, this isn't my choice. The XML file is sent to a 
computer that processes telephone calls (for inmates in prisons) and 
that is the format the vendor is using. 
 
 > > In the test file I have, it takes about 3 seconds per record 
  > > (total of 98 records). Just to see where the hang up was, > > I 
set the visibility of the output field to false, generated 
 > > the file data, then turned it back on and it only takes about 
 > > 3 seconds for the entire file! The problem is that when 
 > > visibility is turned off, I have this big "hole" in the middle 
  > > of the application (about 3/4ths of the screen) which then > > 
comes back on when it's done. 
 >  
  >Working directly in fields is usually a couple orders of magnitude 
 >slower than working in a variable (see this metaphor for lighthearted 
 >explanation of why: 
 ><http://lists.runrev.com/pipermail/use-revolution/2005-May/057143.html>)
. 
 > 
  >Rather than hide the field, could you do the conversion in a variable 
>and then drop the text into the field when you're done? 
 > 
  >Or if the user needs to see the progress while it's happening, maybe 
you >could dump the variable into the field after every hundredth 
record or so. 
 > 
  >Lots of ways to do this, but the key to all of them is to move the 
work >from the field to a variable. 
 > 
 
  I guess the other option I have if I want to "simulate" the field 
being updated on the fly would be to figure out how many lines of text 
are displayed, update the TEXT FIELD that many lines only (while 
creating a variable with the "real" data in it), then when it's done, 
putting the variable into the text field all at once. 
  -- Richard Gaskin Managing Editor, revJournal 
_______________________________________________________ Rev tips, 
tutorials and more: http://www.revJournal.com - 
 
 _______________________________________________ 
 use-revolution mailing list 
 use-revolution at lists.runrev.com 
  Please visit this url to subscribe, unsubscribe and manage your 
subscription preferences: 
 http://lists.runrev.com/mailman/listinfo/use-revolution 


________________________________________________________________________
Check out the new AOL.  Most comprehensive set of free safety and 
security tools, free access to millions of high-quality videos from 
across the web, free AOL Mail and more.
=0



More information about the use-livecode mailing list