Cool, thanks for the comments. I've just now managed to get my boss off the
idea - told him abouts it's inflating costs which did the trick. He seems
to have a strange adversion to Interbase (which is my preference) though,
I'll hit him with the IB concept a few times to see if he changes him mind.
:)
Nahum.
> -----Original Message-----
> From: Neven MacEwan [mailto:[EMAIL PROTECTED]]
> Sent: Monday, June 11, 2001 14:46 PM
> To: Multiple recipients of list delphi
> Subject: Re: Re: Re: [DUG]: Tuning SQL
>
>
> 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"
>
---------------------------------------------------------------------------
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"