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 insertions

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? Ye

Re: Insertion time into the database seems to increase

2012-07-31 Thread Laurent Artaud
Le 31/07/2012 18:53, Alexander Burger a écrit : It causes each time a +File is created to be the list of files in the +Backup object to be extended: (de addFile (Bk P) ... (put!> o 'backups (append (; 'o backups) Bk) ) Thus, the single +Backup object gets

Re: Insertion time into the database seems to increase

2012-07-31 Thread Alexander Burger
Hmm, thinking about it, I see that I wrote nonsense: On Tue, Jul 31, 2012 at 06:53:57PM +0200, Alexander Burger wrote: > However, I suspect that 'request' is not needed here at all, as you > create new +File objects. So 'new' is the way: In fact, I suspect that you of course want to reuse the fil

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 +Bac