Well, since you're using Oracle, modify your do() and prepare() statements as follows:
$dbh->do("sql statement", {ora_check_sql => 0}) ...
$dbh->prepare("sql statement", {ora_check_sql => 0}) ...
And you will make your DBA happy.
-
Ron Reidy
Lead DBA
Array BioPharma, Inc.
I bagged SQLite and used an Oracle DB.
Thanks for the help.
--- Jeff Urlwin <[EMAIL PROTECTED]> wrote:
> To reiterate and define a bit of what Ron asked:
> where is this slow?
>
> What happens if you take out the insert statements?
> What does the time drop to?
> How long does the select take
Perfect! That was it.
thanks a lot!
Doug
At 02:42 PM 9/22/2004 -0700, Lamb Joseph wrote:
Make sure that on the ODBC connection for
"codestriker" on the Advanced tab in Control Panel
that "Named Pipes" is turned off.
--- Doug Rehg <[EMAIL PROTECTED]> wrote:
> Hi -
>
> I an having an issue with DBI
Make sure that on the ODBC connection for
"codestriker" on the Advanced tab in Control Panel
that "Named Pipes" is turned off.
--- Doug Rehg <[EMAIL PROTECTED]> wrote:
> Hi -
>
> I an having an issue with DBI connecting to a
> database.
>
> My environment in IIS 4.0, NT4, SP 6a, Perl 5.8.4,
> w
Hi -
I an having an issue with DBI connecting to a database.
My environment in IIS 4.0, NT4, SP 6a, Perl 5.8.4, with DBI and DBD::ODBC
installed.
when I run a .pl file through the browser, if it does not include a call
the dbi, it runs fine. But add in a call to dbi, and it dies with the
follo
To reiterate and define a bit of what Ron asked: where is this slow?
What happens if you take out the insert statements? What does the time drop to?
How long does the select take alone?
Can you use fetch instead of fetchall_arrayref?
I'd take out the print statements and test there, too...
Jeff
The select statement gets 30,000+ records. After 10
minutes of inserting using the code below it had
processed 7000 records. I would like to have 30,000
records processed in 5 minutes if possible.
--- "Reidy, Ron" <[EMAIL PROTECTED]> wrote:
> Joseph,
>
> Define faster. Where are things slow?
Joseph,
Define faster. Where are things slow? What are your expectations?
-
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-Original Message-
From: Lamb Joseph [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 22, 2004 2:05 PM
To: [EMAIL PROTECTED]
Subject: Faster Inserti
I would like to know how to insert faster using
SQLite.
use strict;
use dbi;
use Date::Manip;
use Diagnostics;
#Connect to the database
my $dbh = DBI->connect("dbi:SQLite:data.dbl")
|| die "Cannot connect: $DBI::errstr";
#MSSQL Server
my $kewilldb = 'LV_KWARCHIVE';
my $dbh_kewill = DBI->conne
On Sep 22, 2004, at 2:37 PM, David Good wrote:
$db = "foo";
$dbcc_sql = "dbcc checkdb($db)";
my $sth = $dbh->prepare($dbcc_sql);
if ($sth->execute($dbcc_sql)){
You passed a parameter to execute and it doesn't need it.
You only need to pass values to execute when you are using place
according to mysql doc and convention,
"set the default value appropriate for the column type. This is 0 for numeric types,
the empty string(' ') for string types, and the "zero" value for date and time types.
unless you see values in storing them in numeric types, perhaps store them as string
Now I've started working on a DBCC script for MS-SQL Server and I'm
having issues similar to my backup problems. If I use "do" without
placeholders, I don't get any of the server status messages (via a
defined odbc_err_handler) indicating
how the DBCC progressed. But when I tried using a "prepare
Wieland and Tim,
Thanks for your inputs. For now we want to go with ROUND function,
that won't abruptly cut off digits and give back a reasonable value.
But for that i now need to know the datatype of all columns in my query,
which
i am ignorant of so far!.
Ravi
Wieland Pusch wrote:
Hello Tim and
Hi all...
i'm having some problems trying to run a script that uses DBD::DB2 inside
mod_perl and the Apache::DBI module, the program runs right when i execute
it as a stand alone perl program. I've already set the ENV for db2home,
db2instance, etc. in startup.pl
This is the trace when connect
(note: this is a response to a different thread, but I'm changing the
subject,
so have changed the subject line).
On Sep 21, 2004, at 5:05 PM, Tim Bunce wrote:
DBD::Oracle simply asks for the columns as strings and it's Oracle
itself
that performs the number to string conversion. DBD::Oracle giv
(I think it was RC7 - the one released end of august this year)
Originally I had an interesting problem - when I'd prepare a query
that called a function taking nvarchar2's as arguments it would work
on the first execution, but in subsequent executions Oracle would pass
NULL's for arguments to my f
Sarkissian, Vahe - NC wrote:
I upgraded MDAC to 2.8 before I posted the first message. I got it from
http://msdn.microsoft.com/data. Unless there's a more recent version that
I'm not aware of, I don't think the bug's in the MDAC layer.
FTR: Provider Version = 08.50.1022 (sqloledb.dll) is still bu
Hello Tim and Ravi,
first of all Tim is right, but you can easily work around with the
format parameter. It seems to me that this is some kind of default
value for the format parameter, that has changed.
Maybe Oracle 8 is so clever to adopt the default format based on the
select column and Oracle
18 matches
Mail list logo
