[Chicago-talk] perl DBI ?
Richard Reina
richard at rushlogistics.com
Wed Mar 16 18:50:30 PST 2005
Thanks for you comments. I believe I will I put in
all in one table afterall.
--- Warren Lindsey <wlindsey at blackhatlounge.net>
wrote:
>
>
> There is a huge performance hit for creating new
> objects in a database
> (DDL) vs inserting/updating/deleting a row (DML)
> because space must be
> allocated and the data-dictionary must be updated.
> It fragments the
> tablespaces in your database as you create and drop
> objects. It breaks
> your transactional integrity because DDL requires a
> commit. It becomes
> very difficult to estimate space usage when objects
> do not last long,
> sometimes they are there, sometimes they aren't. It
> requires the
> application user to have create and drop privileges
> that only your
> application owner should have.
>
> But hey, if you're going to do it, do it right :-)
> Create the table and
> catch the exception/error if it exists. This let's
> the database do the
> work and saves you a trip by not having to lookup
> whether it exists or
> not. Same trick applies when inserting a row into a
> unique/primary key
> column. Let the database do the work.
>
> Richard Reina wrote:
>
> >when I run these lines of code :
> >
> >my $T_NO = 12569;
> >use DBI;
> >my $dbh =
>
>DBI->connect("DBI:mysql:database=carr_search;192.168.0.1",user,password);
> >
> >my $q = "CREATE TABLE IF NOT EXISTS CS_? (
> >ID_NO MEDIUMINT,
> >NAME VARCHAR(30),
> >TYPE CHAR(1)
> >)";
> >my $sth = $dbh->prepare($q);
> >$sth->execute($T_NO);
> >
> >from w/in a program I get:
> >
> >DBD:mysql::st execute failed: You have an error in
> >your SQL syntax near '12569 (
> >ID_NO MEDIUMINT,
> >NAME VARCHAR(30),
> >TYP' at line 2 at ./carr_s.pl line 36.
> >
> >However if I cut and paste the exact same code and
> >make it it's own program then execute it, it works
> >perfectly. Can anyone tell me what's happening and
> how
> >I can fix it?
> >
> >Thanks,
> >
> >Richard
> >
> >
> >_______________________________________________
> >Chicago-talk mailing list
> >Chicago-talk at pm.org
> >http://mail.pm.org/mailman/listinfo/chicago-talk
> >
> >
> _______________________________________________
> Chicago-talk mailing list
> Chicago-talk at pm.org
> http://mail.pm.org/mailman/listinfo/chicago-talk
>
More information about the Chicago-talk
mailing list