|
|
sybperl-l Archive
Up Prev Next
From: Michael Peppler <mpeppler at peppler dot org>
Subject: Re: Sybase-Simple vs DBD::Sybase
Date: Sep 13 2001 8:09PM
Heinz Ringlhofer writes:
> I assumed, this :-)
>
> Thanks a lot ...
>
> but to go a litle bit into detail ...
>
> If the user fetches arrays of rows in a single call this gets memory bound.
> Thats a problem on very large tables and very (you know what i mean)
> users ...
Right - that could be a problem. I think that a valid modification of
Sybase::Simple would be the addition of a default "max row" value (to
avoid exhausting memory). Also, as you probably know, Sybase::Simple
has the HashIter() call that just returns an iterator for large
queries.
In any case Sybase::Simple is due for a new release, I think.
Michael
>
> On Sep 13, 15:36, Michael Peppler wrote:
> > Subject: Re: Sybase-Simple vs DBD::Sybase
> > Heinz Ringlhofer writes:
> > > Now we want to move these techniques also out to our end-users.
> > > Most of them are using a mixture of csh/isql scripts for automated
> > > routine tasks right now.
> > >
> > > As perl seems a much better choice, and pure Sybperl programming
> > > might be too nuch to ask, we have 2 choices, either Sybase_Simple
> > > or DBD.
> > >
> > > I know DBD is more DB independent, but thats not one of our main
> priorities,
> > > the main priority is getting better and more standardized "production"
> code.
> >
> > It's a somewhat difficult choice, as both will provide the necessary
> > functionality.
> > Using Sybase::Simple has the advantage of letting you use the
> > Sybase::CTlib API on the same handle if you want/need to.
> > DBD::Sybase uses the standardized DBI API, which may be easier for
> > people to understand (and there is a book available).
> >
> > Personally I'd use Sybase::Simple, because it has APIs to fetch
> > certain types of data structures with single calls, and so it is even
> > easier to use than DBI - the user only has to know whether they need
> > to fetch single rows, or single values, or lists of rows, etc.
> >
> > Only my opinion, of course :-)
> >
> > Michael
> > --
> > Michael Peppler - Data Migrations Inc. - http://www.mbay.net/~mpeppler
> > mpeppler@peppler.org - mpeppler@mbay.net
> > International Sybase User Group - http://www.isug.com
> >
> >-- End of excerpt from Michael Peppler
>
--
Michael Peppler - Data Migrations Inc. - http://www.mbay.net/~mpeppler
mpeppler@peppler.org - mpeppler@mbay.net
International Sybase User Group - http://www.isug.com
|
