Hello.
        I'm running benchmark tests on Interbase vs SQL Server.
SQL query performances appear to be faster on Interbase than SQL Server,
but in case I nee to collect many rows, the fetch operation is about 3
times longer on IB than on SQL Server.

Am I doing something wrong, or is it normal that I find such figures ?
thanks
        Sam

Hi,

I use them both, too. I would look at the configuration file if I were you
and tune the parameters according to my application's needs. It is almost
completely impossible for MSSQL to work faster. But one has to decide which
kinds of operations have higher precedence and how they should be managed.

And this is something only you can do.

Regards,

Dr.Cem

I'm a new IB user
The only thing I tuned is data cache pages number... Can you tell me in
what kind of manual I could find help on how to do what you told me ?
thanks a lot
Sam

Hi,

It is better you read them all, but administrative things are in OpGuide.pdf
in your install CD. If you don't have the PDFs, search borland site
downloads. Read "OpGuide/ Server Configuration/ Configuring parameters in
ibconfig" specifically.

Dr.Cem

What data are you retrieving (i.e. SQL for tables and SQL for select)?
Is your select 1 select bringing many rows or many selects?
What are you using to connect to IB (BDE, IBX, IBO, FIbPlus)?
Can you send the code snippet for your test (if it is short).
How muchis the difference in speed, can you send test results.

Cheers,

JAC

Jason Chapman
JAC2 Consultancy

Training - Development - Consultancy
Delphi, InterBase, Firebird, OOAD, Development lifecycle assistance,
Troubleshooting projects, QA.....
www: www.jac2.co.uk
Mob: (+44) 07966 211 959 (preferred)
Tel: (+44) 01928 751088

- Come and see me at DCON2003 - 3 talks and a day of preconf training.
- Completed London Marathon 13/4/03 beating my PB by 30 seconds - only 500
short of sponsorship, so if you're feeling generous, throw money at me at
DCON (VICTA - For blind kids).

news:3ECB3BA5.6040600@yahoo.fr...