|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
April 8th, 2004, 04:00 AM
|
||||
|
||||
|
Firebird speed
Hi, I'doing some evaluation and comparison of Firebird, I'm running an inner join with count, group by and order by, over 3 tables of:
Customer: 10281 rows Sales_fact_1997: 86837 rows Product: 1560 rows My query is: Code:
select count(customer.customer_id) as cust_num_prod, product.product_name from customer inner join sales_fact_1997 on customer.customer_id = sales_fact_1997.customer_id inner join product on sales_fact_1997.product_id = product.product_id group by product.product_name order by cust_num_prod desc My Firebird 1.5.0.4027 Release candidate seems faster than MySQL 4.0.10 gamma max, I will do a more accurate benchmark, but I'd like to know your experiences.
__________________
My blog Tutorials about OSS databases, DBMonster ... Contribute to OSS Development, fill bug reports! Developer Shed eSupport Commented my.ini/my.cnf (ADD YOUR OWN CONFIG TRICK) An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries Don't turn your outer joins into inner joins Random data (with a bias)
|
|
| Viewing: Dev Shed Forums > Databases > Firebird SQL Development > Firebird speed |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
