Subject | Re: [ib-support] Firebird and SMP |
---|---|
Author | Daniel Rail |
Post date | 2003-03-02T01:05:38Z |
Hi,
you have to run a lengthy report, on SS the other users might notice a
slow-down, but nobody will notice the same effect in CS.
temporary sort files that gets created when performing a query that
contains a SORT in its PLAN have changed. The physical memory is used
before the hard-drive is used for those sort files. Also, the
performance of the data retrieval has been augmented greatly in FB 1.5
compared to FB 1.0, IB 6.X and IB 7.
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.accramed.ca)
> Hi,Approximately. But it also depends on what the application does. If
>>> When the number of users is small, then yes classic will not perform
> by "Small" you mean: from 1 to abou 200 (2 hundred) ?? .. right ??
you have to run a lengthy report, on SS the other users might notice a
slow-down, but nobody will notice the same effect in CS.
> BTW... can I setup FB SS read cache to something more than 10,000 pages??I forgot to mention something new in FB 1.5. The management for
> (I've noticed that in IB 6.0 this was not recomended)
temporary sort files that gets created when performing a query that
contains a SORT in its PLAN have changed. The physical memory is used
before the hard-drive is used for those sort files. Also, the
performance of the data retrieval has been augmented greatly in FB 1.5
compared to FB 1.0, IB 6.X and IB 7.
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.accramed.ca)