On 23/11/16 19:24, Daniel Miller dmiller@... [firebird-php] wrote:

> Sounds stupid and "expensive" but I'm trying, darn it!

I went through similar agro when I first started with Interbase ...
running on BCB code long before switching to PHP. On one hand relational
databases with transactions seem like a good idea but that also requires
that you understand how it all works. Even today having been using
Firebird for 16 years there are still bits of the process I cock up, but
one thing I have only done once is mess up a database such that I
actually lost data. And THAT was down to not keeping track of which copy
of the database was my master reference ;)

Nowadays my systems run almost faultlessly but I STILL get a deadlock
when two users both 'add a ticket' within 0.01 of a second of one
another. Perhaps once a month. I've spent a LOT of time trying to work
out why and given up. Who ever looses just has to 'add' again and I'm
not sure they even notice - just assume the first click of the mouse
missed ;)

As for 'expensive' ... Just checked a system this morning which has a
combined total of 3 hours running Apache/PHP/Firebird and the windows
code applications ... 6000 hours idle! But response time at busy periods
is more important and sub second page loads are not something you can
achieve sharing the machines with other processes ...

--
Lester Caine - G8HFL
-----------------------------
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk