Michael Peppler
Sybase Consulting
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
Sybase on Linux FAQ
Sybperl FAQ
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

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
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%'


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