> --- In email@example.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
> > 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.
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
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 ^_^