sybperl-l Archive

From: "Stephen H dot Price" <Stephen dot Price at bcm dot tmc dot edu>
Subject: DBlib vs CTlib, please give me a clue!
Date: Oct 9 1997 2:47PM

Greetings to all, I have some questions about the
difference/advantages/performance of DBlib versus CTlib (or should that be
CTlib vs DBlib?) . Which is better? Which is faster? Which is easier?
Clueless minds like myself want to know.
The FAQ states that CTlib was developed with Sybase's help and that Sybase
recommends this as the way to go in the future. My own experience has been
with
DBlib. Initially sybperl 1.x , but I've recently made the transition to
sybperl 2.07. 
My motivation for asking this questions is that my users are complaining
that the Sybase::DBlib, CGI scripts I've developed take too long to
execute. I'd like to improve performance.

Background: 2 CPU Sparc 1000, Solaris 2.5, Perl 5.04_001, Sybperl 2.07, 
Sybase 11 on an ES3000, connecting over a fast ethernet switch.
Simple SQL statements like
select * from whosyall where name like '%smith%'

Thanks

-- 
Stephen H. Price
"Aprendiz de todo, maestro de web."
WebMaster, Senior Systems Engineer
Baylor College of Medicine
Houston, Texas