Subject Re: Embedded Firebird in win app + talking to FB server
Author women_lover_best
Hi Ann,

thanks for the reply..
We have an existing application in Delphi,and database in Firebird..

We have a company which is having regional offices..and each
regional office has sales office..Each sales office has multiple
terminals..POS..present set-up is that each regional office has
server where Firebird databse is set-up..and each terminal in a
sales office has a client application installed ..which interacts
with server..Now,one important requirement is that any transaction
which takes place on any terminal must be updated on server..so that
other terminals are in sync with data..
Now,we r moving to .net..with firebird as database..so we r thinking
if there is any way to reduce the processing time...we dont have the
luxurey of putting a local server in each sales office to which
terminals can connect..
thks

--- In firebird-support@yahoogroups.com, "Ann W. Harrison"
<aharrison@i...> wrote:
> women_lover_best (sic) wrote:
> >
> > well i would like an opinion on an architecture question..
> > I am involved in a project..where users are processing sales at
> > terminals..which r connected to server at district levels..
> > every district has multiple sales office,and each sales office
has
> > multiple POS terminal
> > now..we r using .net and windows app and firebird as database
> > i was wondering if i can use an embedded firebird with win app
which
> > will be deployed at terinals,and after every transaction the FB
> > server at district will be updated..
>
> The difficulty is that the embedded application has exclusive
access to
> the local database. It can access other databases, so if you're
> prepared to include pushing the data to the district as part of
the
> application, it will work.
>
> What problem are you trying to solve? As a general thing, input
from a
> point of sales (POS) terminal is not very quick, so the additional
> overhead of a local TCP connection isn't all that high. If you
can
> handle that overhead, you can separate the operational application
from
> the data upload.
>
> Regards,
>
> Ann