I know this is OT, but just wondering if anyone else has seen this (I
don't belong to any other mailing lists that may have windows
programmers on it)....
I wrote a little program in VBA and Access '97 to suck up a 30MB log
file and pop it into a database so that I can analyze it using SQL.
I switch over to windows NT and Office 2000. Using an exact copy of the
(converted)database everything slows down by about 3000 percent (It
takes the office 97 version about 4 minutes to import it and after 20
minutes in Office 2000, it only did 23%). I think, "OK I'll try ADODB
intead, it should be the native to Office 2000". Same thing, BUT with
task manager running at the same time I see my memory usage go from 50MB
to 90MB while it is running (kill it, office, and memory still didn't
come back down)!! I also noticed that when you use ADO, the MDB file
grows in leaps and bounds. (When the import got to 23% the db file was
about 70MB. I stopped it and used "Tools", "Compress database" and that
brought it down to 5MB).
I went back to office 97 just to be sure and it worked fine. Sound
familiar to anyone?
The program is simple (psuedo code:)
OpenDB = currentdb
Open recorset = table in db
open text file
readline of text file
parse text file into 5 fields
.addnew record
![field1]=xxxx, ![field2]=yyyyy, etc
.update database
read next line of text file unitl EOF
close recordset and db
Shawn K. Tagseth
BBM Bureau Of Measurement
(416)445-9800x2075
