Hi,
I wonder if anyone can help me.
I am using
- Debian Linux
- Perl 5.8.8
- DBI (I do not know how to figure out its version)
- MySQL 5.0.22-Debian_3-log
I want to store and handle data in UTF-8 but so far I have not been able
to force Perl/DBI to do so.
I have created a table using
my
Hi,
Can someone please tell me what the size is when I set it to 1000? Is
it one meg?
Thanks.
Peter
Loo, Peter # PHX wrote:
> Hi,
>
> Can someone please tell me what the size is when I set it to 1000? Is
> it one meg?
It's $your_query_row_size * 1000. It's not a byte size, it's a number
of rows.
Regards,
Philip
Loo, Peter # PHX [mailto:[EMAIL PROTECTED] wrote:
> Sent: Thursday, August 31, 2006 5:17 PM
> To: DBI-Users
> Subject: $dbh->{RowCacheSize} = 1000
>
> Hi,
>
> Can someone please tell me what the size is when I set it to 1000? Is
> it one meg?
>
perldoc DBI:
"RowCacheSize" (integer)
Hi All,
What would you recommend I set this option to if I am sending all the
SELECTed rows to a named pipe?
Peter
-Original Message-
From: Ronald J Kimball [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 31, 2006 2:23 PM
To: Loo, Peter # PHX; DBI-Users
Subject: RE: $dbh->{RowCacheSi
Loo, Peter # PHX wrote:
>
> "RowCacheSize" (integer)
>
> What would you recommend I set this option to if I am sending all the
> SELECTed rows to a named pipe?
I'd recommend you leave it alone, unless your database roundtrips are
really expensive. And if they are, the only thing that can tell y
The reason I asked the question is that the Pro*C program appears to be
writing the output to a file faster than my Perl program can write to
the named pipe. The other end of the named pipe is a native database
utility similar to the sqlldr (nzload). I don't know where the bottle
neck is so I mi
Coombe, Skip wrote:
> dbish would be a very handy tool if I could figure out how
> to use it.
>
> I've read 'perldoc DBI::Shell"
>
> but things start badly when I type 'dbish --debug DBI:SQLite:my.db
>
>
>> Unrecognised options: --debug
>>
You need to include a number to indicate the debugg
I would expect a C program to be able to write to a file faster than any
database loader could load data.
From: Loo, Peter # PHX [mailto:[EMAIL PROTECTED]
Sent: Thu 8/31/2006 5:49 PM
To: Garrett, Philip (MAN-Corporate); DBI-Users
Subject: RE: $dbh->{RowCacheSize}