Hi martin,


On my company;
Sometimes there are bugs, for example our problem;
One hard query working and all server using this query because this hard
query working with %100 cpu rate all on cores.
For Each user application on server running with fbinetserver.exe*32 my
company have 20 users + web clients
If I kill any working %100 cpu fbinetserver.exe*32 my database need to
repair. If I don't make repair its working very very slowly.

regards




From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Martijn Tonies
Sent: Friday, January 04, 2008 4:37 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Which Faster Firebird 2.0 or 1.5 ?

Hello Ali,

>My company using firebird 1.5 but sometimes very slowly, sometimes need to
>repair (backup / restore)
>Can we goto Firebird 2.0? is this fast than 1.5?

If your application becomes slow after a while and a backup/restore cycle
fixes this, it's probably cause by a transaction bug in your application.

Have you tried analyzing why your application is slow?

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com



[Non-text portions of this message have been removed]