Insertion time into the database seems to increase exponentially!

2012-07-31 Thread Laurent Artaud
Hello all! As I like to do something useful when I learn a new language, I decided to do a backup system. I obviously chose to use the integrated database engine to store the meta-data. Unfortunately, the timings I get are starting to frighten me: # Backup returns the number of +File

Re: Insertion time into the database seems to increase

2012-07-31 Thread Alexander Burger
Hi Laurent, As I like to do something useful when I learn a new language, I decided to do a backup system. OK. As you can see, given the progression, it will soon take more time to store the meta-data than processing the data itself. Does anybody see if I made a mistake in my code? Yes,

Re: Insertion time into the database seems to increase

2012-07-31 Thread Alexander Burger
Hi Laurent, ha, our mails just crossed their ways :) What I intended for was to have an immediate list of the +Files for any +Backup, and to be able to know if any +File had no +Backup anymore for cleanup. I guess I'll have to query the database for all the +File linking to a given +Backup,