Gossamer Forum
Home : Products : Gossamer Links : Version 1.x :

mSQL Code - Why???

Quote Reply
mSQL Code - Why???
Hi,

In DBSQL.pm I noticed lines of code refering to mSQL.

Code:
if ($self->{'db_driver'} eq 'mSQL') {
my $query = qq!
SELECT _seq FROM $table
!;
my $sth2 = $DBH->prepare($query) or return $self->error ('CANTPREPARE', $query, $DBI::errstr);
$sth2->execute() or return $self->error ('CANTEXECUTE', $query, $DBI::errstr);
my ($id) = $sth2->fetchrow_array;
$sth2->finish;
return $id;
}

Since Links SQL doesn't support mSQL, why is that code there? Anyway - I'm just checking cause I am 'bout to delete it Smile

------------------
Michael Bray
Review your webhost or find a new one.
www.webhostarea.com
Links SQL User
------------------




Quote Reply
Re: mSQL Code - Why??? In reply to
It might be legacy code from trying to make it work. It's obviously ignored in normal running.
Quote Reply
Re: mSQL Code - Why??? In reply to
The reason for deleting it is to try and get the DBSQL.pm smaller, as its called many times - and I guess every little bit will help with performance.

Anyway - I only have about 60 items in my database, so I don't have to worry about performance yet - but might as well try and do everything before I get to many things added.

------------------
Michael Bray
Review your webhost or find a new one.
www.webhostarea.com
Links SQL User
------------------