posted 18 years ago
I have written an application that creates a fairly large tree structure from an input file and then inserts it into a database. As it parses the tree it inserts records and part of each record is the id of its parent. With really large input files the process gets extremely slow. I'm trying to conceptualize a way to do batch inserts (or anything else to speed up the process).
my basic algorithm is:
Any ideas? It also seems the application speed decreases exponentially while the input size increases linearly (thats a little bit of an overstatement).
-Tad