SA> My experiences with Firebird wasn't really exciting, our setup with SA> firebird eats up the whole cpu when querying data, the database size now SA> is about 200Mb, sure it has those bells and whistles of an almost true SA> ACID rdbms but it's slow, well in our case.
JL> whoooaa! it's impossible! I think you have a misconfiguration with your JL> linux box. Acctually I have an 850MB size db running on Intel STL2 Server JL> with 1 PIII 1GHz processor and a 512MB RAM. And according to the report JL> of my mrtg+snmp it's still running smoothly. It could be that you did not design your tables, indexes and/or queries right. That will drag ANY DBMS' performance down. Firebird is known for not requiring much tuning, so my hunch is that the problem is not likely to lie in the configuration. If you're doing complex queries, then you should use tools to study exactly where the bottleneck is occurring. Some of the Firebird / IB Managers I've seen (running under Windows) come with fairly sophisticated query analysis features though I'm sure you can access these statistics via command line. _ Philippine Linux Users Group. Web site and archives at http://plug.linux.org.ph To leave: send "unsubscribe" in the body to [EMAIL PROTECTED] Fully Searchable Archives With Friendly Web Interface at http://marc.free.net.ph To subscribe to the Linux Newbies' List: send "subscribe" in the body to [EMAIL PROTECTED]
