From: Albert
Date: March 24 1999 5:38pm
Subject: DBI - basic question
List-Archive: http://lists.mysql.com/mysql/911
Message-Id: <36F922F9.D283E9B1@ix.netcom.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Hi All,
I am a newbee with SQL  just getting my feet wet with it.  I
have a few questions.

I have data that will take about 30,000 rows.   If I throw
it all into one table will my performance suffer alot?

Also I am not able to make a connection to my database using
DBI
here is the snippet of code I am using to connect, can
anyone see what is wrong with it?

The error I get is Can't connect to MySQL server on
localhost (61)
my isp has the mysql servers on dedicated machines.  So I
don't think the hostname is localhost?
------------------------------------------
#!/usr/local/bin/perl5 -w

  print "Content-type: text/html\n\n";

 use DBI;
$drh = DBI->install_driver( 'mysql' );
$dbh = $drh->connect(
'hostname','databasename','myusername','mypassowrd' ) ;
 print "Cannot connect: $DBI::errstr\n"  unless $dbh;
$dbh->disconnect;
 exit;
------------------------------------------

Thanks for all the help!!
Albert