Maybe gbak without garbage collection?

-steve

On Tue, 2005-09-27 at 12:03 -0700, grostoon wrote:

> The database file has a size of 50Mo.
> Here are the times taken by gbak to backup the database :
>
> real 55m46.374s
> user 16m20.450s
> sys 33m40.040s
>
> After a restore of the database, speed is ok.
>
> However, I'm still surprised by the time spent by gbak and the select
> count(*) even if the select does a full table scan. The database is
> "just" 50Mo after all ...
>
> I'm going to do the same test with postgresql, mysql (with innodb
> tables) and oracle to see what timings I get.
>
> Regards,
>
> Toon.
>
>
>
> Steve Wiser <steve@...> wrote:
>
> How does it perform after a backup and restore is done to the
> database?
>
> -steve
>
> On Tue, 2005-09-27 at 04:49 -0700, grostoon wrote:
>
> > Hi all,
> >
> > In order to validate my build of FB 1.5 for AIX 5.1, I made a few
> > tests with
> > isql and
> > I found a basic test for which FB is very very slow. I first
> suspected
> > my
> > AIX build; but doing
> > the same test on a Linux box produced the same behaviour.
> >
> > Here is the test :
> >
> > create database 'test.fdb';
> > create table tbl1 (name char(10), age integer);
> > create table tbl2 (name char(10), age integer);
> > create index idx1 on tbl1 (name);
> > create index idx2 on tbl2 (name);
> > create index idx3 on tbl1 (age);
> > create index idx4 on tbl2 (age);
> > insert into tbl1 values ('aaaa', 1);
> > insert into tbl1 values ('bbbb', -20);
> > insert into tbl2 select * from tbl1;
> > insert into tbl1 select * from tbl2;
> > commit;
> > insert into tbl2 select * from tbl1;
> > insert into tbl1 select * from tbl2;
> > commit;
> > ... sequence repeated until there are about 300000 rows in tbl1 and
> > tbl2
> > insert into tbl2 select * from tbl1;
> > insert into tbl1 select * from tbl2;
> > commit;
> >
> > Now, activate stats : set stats;
> > Then select count(*) from tbl1 gives :
> > COUNT
> > ============
> >
> > 392836
> > Current memory = 1506128
> > Delta memory = 196
> > Max memory = 1711452
> > Elapsed time= 0.41 sec
> > Cpu = 0.00 sec
> > Buffers = 75
> > Reads = 5244
> > Writes = 0
> > Fetches = 796154
> >
> > Then do a delete from tbl1;
> > Current memory = 1702324
> > Delta memory = 196380
> > Max memory = 1711452
> > Elapsed time= 1.28 sec
> > Cpu = 0.00 sec
> > Buffers = 75
> > Reads = 5245
> > Writes = 5165
> > Fetches = 1974662
> >
> > commit;
> > Current memory = 1493880
> > Delta memory = -208444
> > Max memory = 1711452
> > Elapsed time= 0.00 sec
> > Cpu = 0.00 sec
> > Buffers = 75
> > Reads = 2
> > Writes = 75
> > Fetches = 2
> >
> >
> > And now redo a select count(*) from tbl1 :
> > COUNT
> > ============
> > 0
> >
> > Current memory = 3837432
> > Delta memory = 2338664
> > Max memory = 3837536
> > Elapsed time= 3346.55 sec
> > Cpu = 0.09 sec
> > Buffers = 596
> > Reads = 210708549
> > Writes = 793226
> > Fetches = 228875455
> >
> > As you can read, it takes 3346.55 sec of elapsed time (on an Athlon
> XP
> > 2600+) !!!
> >
> > Is this a known issue/bug ?
> > What can be done to get acceptable performance ? (any patch
> needed ?)
> >
> > Regards,
> >
> > Toon.
> >
> >
> > ---------------------------------
> > Yahoo! for Good
> > Click here to donate to the Hurricane Katrina relief effort.
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> >
> >
> > ------------------------ Yahoo! Groups Sponsor
> >
> > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> >
> > Visit http://firebird.sourceforge.net and click the Resources item
> > on the main (top) menu. Try Knowledgebase and FAQ links !
> >
> > Also search the knowledgebases at http://www.ibphoenix.com
> >
> > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> >
> > Yahoo! Groups Links
> >
> >
> >
> >
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>
>
>
>
> SPONSORED LINKS
> Technical support Computer technical support Compaq computer technical
> support Compaq technical support Hewlett packard technical support
> Microsoft technical support
>
> ---------------------------------
> YAHOO! GROUPS LINKS
>
>
> Visit your group "firebird-support" on the web.
>
> To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service.
>
>
> ---------------------------------
>
>
>
>
> ---------------------------------
> Yahoo! for Good
> Click here to donate to the Hurricane Katrina relief effort.
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------ Yahoo! Groups Sponsor
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
>


[Non-text portions of this message have been removed]