Hi Marcus,

Mainly 2 pit falls: performance and security.

Firebird does not do any kind of packet compression, so on the internet you
will notice some lack of performance.
Security is always a problem on the internet. :-)

I use ZeBeDee for that. You can find a small doc on Firebird web site. Any
problem you can email me.

Artur

----- Original Message -----
From: "Marcus" <marcus.monaghan@...>
Newsgroups: egroups.ib-support
To: <ib-support@yahoogroups.com>
Sent: Wednesday, February 05, 2003 12:02 PM
Subject: [ib-support] FB over the net


> All,
>
> I am currently doing some investigation into ways of allowing clients to
> query a data over the net, not through a web browser. We currently have a
> client base of about 250-300 concurrent users, all connecting over the
> internet to our central processing application. The client application
> currently reads a local MyBase xml file for reference data. This data has
> no more than 2500 records. This has worked fine as the users have
> downloaded the MyBase file via an FTP site every day to get the latest
> data. However this file is about to be increased to over 60,000 records
> with an expectation for this to increase (double) later in the year.
>
> What I would like to do is have a Firebird database sitting on our server
> and allow the client to query it directly over the net. Has anyone done
> this before? What pit falls must I look out for? I'm just after some
> experienced guidance on this :0)
>
> Regards,
> Marcus.
>