I threw together a little app to load up some rather large text files into a new SQL Server 2005 database I setup (we’re talking about 6 gigs of text). It’s now been running for 48 hours straight, reading a line at a time, building an
insert statement, and passing it to the database.
When last I looked (call it 20 minutes ago), it had processed 155 million records, and was only now in the T’s in the final (and largest - about 4.5 gigs) file.
I can just barely see the light at the end of the tunnel, where I’ll get my development laptop back (foolish me ran all this in a debug session - probably also not the brightest move ever).
Hey, could be worse… It could be written in Java… :D