Hi again,

I don't know if I have to disagree with Paul, but as a test I backuped and
restored the database and I changed the buffersize from 4096 to 2048 and it
looks slower to me now ???

Nico

-----Oorspronkelijk bericht-----
Van: Paul Reeves [mailto:paul@...]
Verzonden: donderdag 19 april 2001 7:34
Aan: ib-support@yahoogroups.com
Onderwerp: Re: [ib-support] Page buffers


Aage Johansen wrote:

>
> ....
> >
> > If you have the time and a suitable database I'd be happy to share what

I was

> > doing with you. Suitable, in this case, is a database with two tables

each large

> > enough to be bigger than the largest possible cache. This allows us to

a) See

> > how long it takes to fill the cache and b) see the benefit of a full

cache on

> > repeating the select. The second large table is used to flush the first

table

> > from the cache.
> >
> > Paul
> > --
>
> If this can be done at my workplace, I have a database with about 30
> tables, total size 2.5-3GB. One of the tables has 6.000.000+ records
> (uncompressed records size approx 200B), another table has 2.000.000+
> records (haven't counted bytes, but will probably fit the specs). It is
> running on IB/5.6 (2x200MHz PPro, WinNT4SP6 - soon to be moved to
> 2x800MHz Zeon and fast disks, Win2k). If your test setup can be run
> without to much disrupting of daily database use, I'd like to know more.
> Another possibility is an 800MB database I have at home, running on
> 550MHz PIII.
>

I'll see if I can properly automate the tests and get back to you. It wont
be
this week.

Paul
--

Paul Reeves
http://www.ibphoenix.com
taking InterBase further



To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/