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"

Reply via email to