Re: Recommendation

From: Andrew (andrew_at_andrew.invalid)
Date: 05/30/04 

Date: Sun, 30 May 2004 11:12:46 -0500

In firebird, you (used to?) need a seperate connection (rather than session)
to keep the recordset data stable. This may have been fixed. I usually
deploy the multi-user version and simply connect from the local PC, works
like a champ and has zero speed related issues that I have ever noticed.

I would highly recommend Firebird. There is no reason not to use it. It is
very easy to deploy, fast, extremely reliable (I have had ZERO database
problems in 3 years), flexible, supports multiple platforms, direct php
support, ODBC, REAL joins, supports external tables. Start using it and
you'll ask yourself why you waited.

The only downside to Firebird is it does not support Boolean, and AutoInc
fields. It uses generators and triggers to accomplish AutoInc. If you
switch your dataset components to IBO or IBX, they automatically handle
these little nuances for you. Booleans are not an issue, its a matter and
changing code FieldByName('BoolField').AsBoolean to
(FieldByName('BoolField').AsString = 'Yes'), or
(FieldByName('BoolField').AsInteger = 1) (etc.,etc.,etc.) on reads and
making a function (i.e. FieldByName('BoolField').AsString :=
BoolValue(BooleanField) (returns: yes/no)) for updates.

I hope you found this helpful!

"Exorcist" <dsf> wrote in message news:40b8b91c@newsgroups.borland.com...
> I have one indy server and in each thread of server i create one session
in
> nexusdb (one session per for table).
> Each thread (indy server thread) has 10 tables and theres max 100 users
> threads.
> I have used dbisam and easytable and flashfiler too, and nexusdb seems
> fastest.
> So i have own protocol for writing and deleting data.
> I dont know if its good idea since i have simple protocol and hundred of
> users changing few records each minute.
>
>
> "Lee" <lee_jenkins@No_Spamming_datatrakpos.com> wrote in message
> news:40b8b4eb$1@newsgroups.borland.com...
> >
> > From what I've read, FB embedded supports only one (exclusive?)
> connection.
> > In addition, shouldn't you use a separate connection for each thread in
a
> > threaded app? Of course, FB server would handle it quite well and its
> very
> > easy to deploy. We do it all the time.
> >
> > Warm Regards,
> >
> > Lee
> >
> >
> > "Exorcist" <dsf> wrote in message
news:40b8b40d@newsgroups.borland.com...
> > > I have project in d7 with trial nexusdb.
> > > 30-40 tables, 100 users (in own thread) etc.
> > > is there any free replacement for this Nexusdb (embeded),
> > > for example firebird.
> > > What to use with firebird ?
> > > Or theres some other fast db???
> > >
> > >
> > >
> > >
> >
> >
>
>

Relevant Pages

  • Re: RWW Timing
    ... I understand that you want to monitor when and how ... > to an internal Windows XP or Terminal Server computer. ... SBS creates a connection to the internal client on port 3389 which is ... But it can not tell which one session from the RWW, ...
    (microsoft.public.windows.server.sbs)
  • RE: OS X RDC client does not support Session Directories (read)
    ... When you make the initial connection (whether you have an existing session ... the server attempting to map sound, ... This must be the "command packet" that is telling the client to ...
    (microsoft.public.windows.terminal_services)
  • Re: OS X RDC client does not support Session Directories (read)
    ... > When you make the initial connection (whether you have an existing session ... > the server attempting to map sound, ... This must be the "command packet" that is telling the client ...
    (microsoft.public.windows.terminal_services)
  • RE: TS disconnects when minimized a couple minutes
    ... Thank you for posting in SBS newsgroup. ... I understand if you minimize the terminal session ... the connection will be disconnected after ... If you have installed ISA Server 2004, the setup process will change the ...
    (microsoft.public.windows.server.sbs)
  • Re: I think this is a TS session issue with RDC.... Please help!!!
    ... Have you checked in TS Manager if there is a disconnected session ... establish a connection with another user account, ... MCSE, CCEA, Microsoft MVP - Terminal Server ... The time-out limit on disconnected sessions and all other ...
    (microsoft.public.windows.terminal_services)