I am developing a program that will be used in a small business scenario. What I want to do is make a local small database from years worth of data files. I used SQLite to make and maintain the database but the problem is writing all of the data to this database is extremely slow. I have to process thousands of files. The database needs to be able to store all sorts of information about a product and how many of each item were sold everyday of the year. That's where I think the program gets bogged down. It creates a new column in the database for sales on a certain day. There has to be a more efficient way to solve this and any pointers or ideas would be great.
