----- Original Message -----
From: "Adam" <s3057043@...>
To: <firebird-support@yahoogroups.com>
Sent: Wednesday, November 09, 2005 8:35 AM
Subject: [firebird-support] Re: Multi-file database
> --- In firebird-support@yahoogroups.com, "Yaten Kou" <yaten@i...> wrote:
> >
> > hi list,
> > i was trying multi-file database but i don't seem to be getting the
> > behaviour that i'm expecting.
> >
> > below is a sample scenario to further illustrate my problem
> >
> > The command:
> > gbak -c sample.fbk test-01.fdb 40960 test-02.fdb 40960 test-03.fdb 40960
> > test-04.fdb
> >
> > The result:
> > -rw------- 1 firebird firebird 535552 Nov 9 07:15 test-01.fdb
> > -rw------- 1 firebird firebird 2048 Nov 9 07:15 test-02.fdb
> > -rw------- 1 firebird firebird 2048 Nov 9 07:15 test-03.fdb
> > -rw------- 1 firebird firebird 2048 Nov 9 07:15 test-04.fdb
> >
> >
> > i was expecting a different result, i was expecting that test-01 to
> test-03
> > would be
> > limited to 40960bytes (plus header) and test-04 would contain the
> rest of
> > the data.
> >
> > is that correct or i'm missing something?
> >
>
> The size you are specifying is not in bytes, but in database pages.
> Database pages are by default 4K, so if you want 40960, then limit it
> to 10000.
sir jakub also pointed that out to me, thanks for all your help ^_^
i'm enlightened ^_^
> Out of curiousity, why are you limiting it to 40MB chunks? It doesn't
> strike me as a limit of any recent OS.
>
> Adam
t's just a test database, i wouldn't want to test my actual data coz the
size is now 3GB+
I've been using interbase/firebird for 5 years and i'm sticking to it ^_^
i'm loyal coz i'm
very satisfied. I mostly use my database on Multilevel Marketing programs
and you probably
have an idea how gruesome Binary type MLM works. the rate of growth of your
database is increasing
exponentially. ^_^
Just to share my experience, i tested MySQL as a light weight solution to
our Asterisk PBX PIN Database.
The result was horrible, a table with less than 100000 records is taking too
long to query, while my IB/FB
database for our MLM contains millions of records and i can access it with
ease. I used index on both db,
yet the speed difference is very big. Oh well, like i said, just sharing my
experience. If the reason for
slow access in MySQL is my negligence for missing something, then still
IB/FB is better coz i never needed
to look for solutions to make it fast coz it is naturally fast ^_^