Subject | Re: [firebird-support] Performance Problem |
---|---|
Author | Anderson Farias |
Post date | 2007-08-27T12:46:26Z |
Hi Rambabu,
Are you sure your performance problems came from FB? Did you debug through
your code?
I've deployed 1.5.3 Classic over at leat 3 Windows SMP boxes (with and
without SCSI RAID) and it performs great... from my little experience, a
*lot* better than SuperServer on the very same machines.
BTW, even your best performance, 9 min for 15k rows seems bad. I believe
this should not be more 30 sec (executing the select based on an index,
fetching rows, writing to some text file).
Regards,
Anderson
Are you sure your performance problems came from FB? Did you debug through
your code?
I've deployed 1.5.3 Classic over at leat 3 Windows SMP boxes (with and
without SCSI RAID) and it performs great... from my little experience, a
*lot* better than SuperServer on the very same machines.
BTW, even your best performance, 9 min for 15k rows seems bad. I believe
this should not be more 30 sec (executing the select based on an index,
fetching rows, writing to some text file).
Regards,
Anderson
----- Original Message -----
From: <rambabu.piridi@...>
>4. Modified the sever type to Classic server and started export of 15,000
>records on multiprocessor >machine, even then also it took more than 1
>hour.