(Fwd) Help in installing DBD - DB2 for Perl

2010-06-02 Thread Tim Bunce
- Forwarded message from raghav sridharan raghava...@yahoo.co.in - Date: Wed, 2 Jun 2010 06:56:01 +0530 (IST) From: raghav sridharan raghava...@yahoo.co.in To: tim.bu...@pobox.com Subject: Help in installing DBD - DB2 for Perl X-Mailer: YahooMailRC/374.4 YahooMailWebService/0.8.103.269680

Make Test Failed For DBD-Oracle 1.24

2010-06-02 Thread Yeow Yiew Choong-PBKN64
Hi, I have problem when I run make test for DBD::Oracle 1.24 module. My Oracle database is on remote server. Oracle database version is 10g, and my Oracle client is version 10.2 (64bit) on HP-UX 11.11(PA-RISC) 64bit OS. I can run splplus to connect to remote database. My perl is version 5.8.3.

DBD::Oracle and bulk operations

2010-06-02 Thread Johannes Gritsch
Hi! Since I came into this topic while writing a script: What does DBD::Oracle know about bulk operations? In PL/SQL you can speed up your cursor loops by using bulk fetches and/or bulk updates/inserts. Instead of operating on single rows you use arrays of rows. Since DBI does not support

Re: DBD::Oracle and bulk operations

2010-06-02 Thread John Scoles
Johannes Gritsch wrote: DBI does support bulk operations and what you are asking about is the array interface. It does it though the 'execute_array' http://search.cpan.org/~timb/DBI-1.611/DBI.pm#execute_array method. and it is available to all DBD drivers. DBD::Oracle is special as it

RE: Make Test Failed For DBD-Oracle 1.24

2010-06-02 Thread John Scoles
Never ran into that myself but this link looks like the same error http://forums11.itrc.hp.com/service/forums/questionanswer.do?admit=109447626+1272030523151+28353475threadId=1078200 cheers John Subject: Make Test Failed For DBD-Oracle 1.24 Date: Tue, 1 Jun 2010 19:04:44 +0800 From:

Re: Some DBI question -

2010-06-02 Thread newbie01 perl
Hi Peter, Yes, that is correct ... am referring to these commands ... If I already have the .sql file that has all the formatting in them, is it okay to just run @x.sql from the Perl DBI script ... BTW, you mentioned some template toolkit, never heard of those ... can you elaborate on them or

Re: Some DBI question -

2010-06-02 Thread Bob McGowan
On 06/02/2010 04:17 PM, newbie01 perl wrote: Hi Peter, Yes, that is correct ... am referring to these commands ... If I already have the .sql file that has all the formatting in them, is it okay to just run @x.sql from the Perl DBI script ... BTW, you mentioned some template toolkit,

Re: SQLite - Time to build a database

2010-06-02 Thread Bart Lateur
On Wed, 26 May 2010 10:46:43 +1000, Owen wrote: So I read the main database row by row, tested the validity of one column, and inserted the good rows into a new database. This process took 27 minutes on a fairly recent desktop computer. ( about 1 rows a minute or 170 a second ) I thought

Re: SQLite - Time to build a database

2010-06-02 Thread John R Pierce
Bart Lateur wrote: 2) edit the C source of SQLite and replace the fsync() with fflush(), which ought to be around 100 times faster, but which isn't garanteed to withstand computer crashes, if it goes down before the data is finally stored on disk - not ideal in the eye of ACID perfectionists.

Re: (Fwd) Help in installing DBD - DB2 for Perl

2010-06-02 Thread Jonathan Leffler
On Wed, Jun 2, 2010 at 1:36 AM, Tim Bunce tim.bu...@pobox.com wrote: - Forwarded message from raghav sridharan raghava...@yahoo.co.in - Date: Wed, 2 Jun 2010 06:56:01 +0530 (IST) From: raghav sridharan raghava...@yahoo.co.in To: tim.bu...@pobox.com Subject: Help in installing DBD -