Re: FrontBase vs. MySQL performance comparisons?

Hi Georg,

Thanks very much for your reply. Your feedback is greatly  
appreciated. We've certainly had some performance issues lately with  
our database, but with some careful crafting of some raw SQL queries,  
we've been able to increase our performance quite a bit now. A bunch  
of times our database starts to slow down because we're writing  
feverishly to the it and it sometimes can't keep up with all the  
writes, so it starts to block and cause the rest of our applications  
to slow down considerably. But I think those issues can be resolved  
by tuning the caches some more. Or perhaps adding some code in our WO  
apps to slow down the writing process at that end.

Thanks,

____________________________________________________________________
Brendan Duddridge | CTO | 403-277-5591 x24 |  [email protected]

ClickSpace Interactive Inc.
Suite L100, 239 - 10th Ave. SE
Calgary, AB  T2G 0V9

http://www.clickspace.com

On May 28, 2005, at 12:34 AM, Georg Tuparev wrote:

> Hi Brendan,
>
> As far as I can judge, every DB engine has its strengths and  
> weaknesses (well almost... if you do not consider few Mickey Mouse  
> databases pre-installed on Mac...). In the past we evaluated MySQL  
> and others for similar reasons as you do now. For some small or  
> moderately sized databases schemas MySQL could be a bit faster (I  
> do not remember details any more, but I believe the best we got was  
> something like 10-15%). But with the size growing, FB was a very  
> clear front runner. Actually, we had situations, where MySQL  
> stopped running at all, where FB was happily outperforming any  
> other vendor.
>
>
> later...
>
> gt
> On May 26, 2005, at 9:51 PM, Brendan Duddridge wrote:
>
>
>>
>> Well, we are trying to optimize our queries as much as we can, but  
>> I thought perhaps some databases may handle certain queries better  
>> than other databases (especially multi-table joins), so that's why  
>> I was looking into it.
>>
>>
> Georg Tuparev
> Tuparev Technologies
> Klipper 13
> 1186 VR Amstelveen
> The Netherlands
> Mobile: +31-6-55798196
>
>