Subject | Re: Embedded Firebird in win app + talking to FB server |
---|---|
Author | women_lover_best |
Post date | 2005-06-21T05:00:46Z |
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:
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:has
> >
> > 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
> > multiple POS terminalwhich
> > 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
> > will be deployed at terinals,and after every transaction the FBaccess to
> > server at district will be updated..
>
> The difficulty is that the embedded application has exclusive
> the local database. It can access other databases, so if you'rethe
> prepared to include pushing the data to the district as part of
> application, it will work.from a
>
> What problem are you trying to solve? As a general thing, input
> point of sales (POS) terminal is not very quick, so the additionalcan
> overhead of a local TCP connection isn't all that high. If you
> handle that overhead, you can separate the operational applicationfrom
> the data upload.
>
> Regards,
>
> Ann