Nahum
Pervasive SQL (aka Scalable SQL aka Netware SQL) is an SQL engine that sits
on top of Btrieve (Server ISAM)
Popularity (if it has any) is due to the large Btrieve installed base
porting to it as a quick "i'm now C/S" statetgy
(Solomon, AccPac, Sage spring to mind)
Pervasive seem to be doing well with their Web Dev tools (though they seem
to be focused on Pervasive.SQL 2000 now)
I wouldn't use it (out of choice) I think the world has moved on, , IB is
way better!,
We have a client with it (part of our dataflex daze) and recently the query
optimiser spontaneously
decided to 'reoptimize' the query ignoring indexes and replacing it with a
linear search,
execution time went from seconds to days! Pulled the whole DB Down (this was
Pervise.SQL 7 release prior to 2000)
Only solution was to purge data (Not Acceptable)
HTH
Neven
----- Original Message -----
From: Nahum Wild <[EMAIL PROTECTED]>
To: Multiple recipients of list delphi <[EMAIL PROTECTED]>
Sent: Monday, 11 June 2001 14:01
Subject: RE: Re: Re: [DUG]: Tuning SQL
> Does anybody know anything about Pervasive.SQL ??? My boss wants me to
look
> at it and the only info I can quickly find about it is from the makers of
> it. It used to be called 'Btrieve' or something like that.
>
> Cheers in advance,
> Nahum.
>
> > -----Original Message-----
> > From: Sandeep [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, June 11, 2001 13:53 PM
> > To: Multiple recipients of list delphi
> > Subject: Re: Re: Re: [DUG]: Tuning SQL
> >
> >
> > On 11 Jun 2001, at 13:05, Neven MacEwan wrote:
> >
> > > Sandeep
> > >
> > > Do you want URL's where PostgreSQL outperforms Oracle?
> > > Anyway I thought we were comparing Open Source DB's
> >
> > U mean to say PostgreSQL is the best RDBMS around?
> >
> > Sandeep
> >
> > Software Developer
> > CFL
> > [EMAIL PROTECTED]
> > http://www.cfl.co.nz
> >
> > --------------------------------------------------------------
> > -------------
> > New Zealand Delphi Users group - Delphi List -
> > [EMAIL PROTECTED]
> > Website: http://www.delphi.org.nz
> > To UnSub, send email to: [EMAIL PROTECTED]
> > with body of "unsubscribe delphi"
> >
> --------------------------------------------------------------------------
-
> New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
> To UnSub, send email to: [EMAIL PROTECTED]
> with body of "unsubscribe delphi"
>
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe delphi"
