I have script that compares the invoice number that I inputed to a text file that contains unprocessed invoice numbers. When the inputed number match with one of the unprocessed invoice, a voice message would play.
However the list of unprocessed invoice number grew so large that it takes a while for the script to go through the list. Is there a way to put the list in the memory or RAM so that it will run faster? The file or list is on the local drive.
We're running this script on older P2 Win98 PCs and the invoice numbers are barcoded so we just scan the barcode.
AFAIK, when KiX opens a file, it reads it all into memory. If you have a performance issue, you are probably hitting the pagefile and need more memory.
_________________________
Give a man a fish and he will be back for more. Slap him with a fish and he will go away forever.
#178544 - 2007-07-3009:47 AMRe: load then read text from RAM
[Re: Richard H.]
Arend_Arend_ MM club member
Registered: 2005-01-17
Posts: 1896
Loc: Hilversum, The Netherlands
Perhaps the FileSystem Object would help out here, you can read 1 line at a time with that. Although like Les said, this will open the entire file in memory too but I like to think FSO handles files quicker then Kix does.
Code:
Dim $Script, $FSO, $ReadScript
$Script = "C:\boot.ini"
$FSO = CreateObject("Scripting.FileSystemObject")
$ReadScript = $FSO.OpenTextFile($Script, 1)
While Not $ReadScript.AtEndOfLine
? $ReadScript.ReadLine
Loop
$ReadScript.Close
$FSO = ""
