Re: many-inserts go faster the second time

2009-10-06 Thread Joerg Bruehe
Hi Bennett, all, sorry about the delay, I was somewhat busy. Bennett Haselton wrote: > At 02:53 AM 10/2/2009, Joerg Bruehe wrote: >> Hi Bennett, all! >> >> >> Bennett Haselton wrote: >> > [[...]] >> >> Your "fairy dust" is called "access pattern", evaluated by a LRU or >> similar policy. >> >> D

Re: many-inserts go faster the second time

2009-10-02 Thread Wm Mussatto
On Fri, October 2, 2009 12:28, Bennett Haselton wrote: > At 02:53 AM 10/2/2009, Joerg Bruehe wrote: >>Hi Bennett, all! >> >> >>Bennett Haselton wrote: >> > At 08:24 AM 9/25/2009, Dan Nelson wrote: >> >> In the last episode (Sep 25), Bennett Haselton said: >> >> > I have a script that runs several

Re: many-inserts go faster the second time

2009-10-02 Thread Bennett Haselton
At 02:53 AM 10/2/2009, Joerg Bruehe wrote: Hi Bennett, all! Bennett Haselton wrote: > At 08:24 AM 9/25/2009, Dan Nelson wrote: >> In the last episode (Sep 25), Bennett Haselton said: >> > I have a script that runs several times in the evening, and on each >> run it >> > adds several thousand en

Re: many-inserts go faster the second time

2009-10-02 Thread Joerg Bruehe
Hi Bennett, all! Bennett Haselton wrote: > At 08:24 AM 9/25/2009, Dan Nelson wrote: >> In the last episode (Sep 25), Bennett Haselton said: >> > I have a script that runs several times in the evening, and on each >> run it >> > adds several thousand entries to a table. >> > >> > On the first run,

Re: many-inserts go faster the second time

2009-09-25 Thread Bennett Haselton
At 08:24 AM 9/25/2009, Dan Nelson wrote: In the last episode (Sep 25), Bennett Haselton said: > I have a script that runs several times in the evening, and on each run it > adds several thousand entries to a table. > > On the first run, it adds the entries rather slowly. But then on all > subs

Re: many-inserts go faster the second time

2009-09-25 Thread Dan Nelson
In the last episode (Sep 25), Bennett Haselton said: > I have a script that runs several times in the evening, and on each run it > adds several thousand entries to a table. > > On the first run, it adds the entries rather slowly. But then on all > subsequent runs (usually about a minute or two l