Hi,
i am trying to get in contact with Tim bunce. He is an old friend of
mine and i have lost his address. can you help?
here is mine..with this email
and easy version: info@lindawestmore.com
Thanks for your help...in anticipation
Linda
www.lindawestmore.com
On Sun, Dec 18, 2005 at 12:41:13PM +0000, Linda Westmore wrote:
>
> Hi,
>
> i am trying to get in contact with Tim bunce. He is an old friend of
> mine and i have lost his address. can you help?
Hi Linda! Great to hear from you. I'll reply separately.
Tim.
On Mon, Dec 19, 2005 at 02:04:27PM +0000, Tim Bunce wrote:
>On Sun, Dec 18, 2005 at 12:41:13PM +0000, Linda Westmore wrote:
>>
>> Hi,
>>
>> i am trying to get in contact with Tim bunce. He is an old friend of
>> mine and i have lost his address. can you help?
>
>Hi Linda! Great to hear from you. I'll reply separately.
>
>Tim.
>
Isn't it amazing how DBI and Perl can bring together lost friends!
Yet it brings together so much more at the same time...
Perl for president!
--0-564813032-1135012783=:89407
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Yeah. It's amazing.
Merry Christmas and Happy New Year to all members of this group.
Thanks,
Adit
Perl Fanatic
On Mon, Dec 19, 2005 at 02:04:27PM +0000, Tim Bunce wrote:
>On Sun, Dec 18, 2005 at 12:41:13PM +0000, Linda Westmore wrote:
>>
>> Hi,
>>
>> i am trying to get in contact with Tim bunce. He is an old friend of
>> mine and i have lost his address. can you help?
>
>Hi Linda! Great to hear from you. I'll reply separately.
>
>Tim.
>
Isn't it amazing how DBI and Perl can bring together lost friends!
Yet it brings together so much more at the same time...
Perl for president!
Aditya
Aditya Dutt, Duke Energy Corp.,S Tryon,Charlotte,NC 28262,US. Tel.Ph:+1-972-697-6894 "Do not follow where the path may lead,Instead go where there is no path and leave a trial"
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--0-564813032-1135012783=:89407--
On Mon, Dec 19, 2005 at 01:28:32PM -0500, Mladen Gogala wrote:
> On Mon, 19 Dec 2005 14:04:27 +0000, Tim Bunce wrote:
>
> > On Sun, Dec 18, 2005 at 12:41:13PM +0000, Linda Westmore wrote:
> >>
> >> Hi,
> >>
> >> i am trying to get in contact with Tim bunce. He is an old friend of
> >> mine and i have lost his address. can you help?
> >
> > Hi Linda! Great to hear from you. I'll reply separately.
> >
> > Tim.
>
> Why is it that I can't get a response to my question: when will
> DBD::Oracle fully support Oracle's array interface?
I don't get paid to work on DBD::Oracle. It's a hobby, and one that
generally gives me far more headaches than it could possibly be worth.
Patches welcome. Volunteers to help maintain it also welcome.
Take your pick.
Tim.
Tim Bunce writes:
> On Mon, Dec 19, 2005 at 01:28:32PM -0500, Mladen Gogala wrote:
> >
> > Why is it that I can't get a response to my question: when will
> > DBD::Oracle fully support Oracle's array interface?
>
> I don't get paid to work on DBD::Oracle. It's a hobby, and one that
> generally gives me far more headaches than it could possibly be worth.
>
> Patches welcome. Volunteers to help maintain it also welcome.
> Take your pick.
>
I for appreciate your work on DBI/DBD! I have been working with
DBD::Oracle for a few years now, and I am not 100% certain what is
being requested? What part isn't supported?
--
C Wayne Huling
On 12/20/2005 09:06:07 AM, c.w.huling@pobox.com wrote:
> Tim Bunce writes:
> > On Mon, Dec 19, 2005 at 01:28:32PM -0500, Mladen Gogala wrote:
> > >=20
> > > Why is it that I can't get a response to my question: when will=20
> > > DBD::Oracle fully support Oracle's array interface?=20
> >=20
> > I don't get paid to work on DBD::Oracle. It's a hobby, and one that
> > generally gives me far more headaches than it could possibly be worth.
> >=20
> > Patches welcome. Volunteers to help maintain it also welcome.
> > Take your pick.
> >=20
>=20
> I for appreciate your work on DBI/DBD! I have been working with
> DBD::Oracle for a few years now, and I am not 100% certain what is
> being requested? What part isn't supported?
Use of the array interface isn't supported. If I do bind_param_array and ex=
ecute_array
DBD::Oracle will break it into single step executions. Recently, I had to l=
oad a file=20
of 20,000,000 records into a database. I wrote a perl script using bind_par=
am_array and
execute_array and it worked much slower then anticipated. The reason was th=
e array interface.
I had to re-write the file itself into a format that could be used by SQL L=
oader and=20
re-do the job. Perl DBI isn't very useful as a loading tool without the sup=
port for the
array interface.=20
>=20
> --=20
> C Wayne Huling
>=20
>=20
--=20
Mladen Gogala
http://www.mgogala.com
>
> On 12/20/2005 09:06:07 AM, c.w.huling@pobox.com wrote:
>> Tim Bunce writes:
>> > On Mon, Dec 19, 2005 at 01:28:32PM -0500, Mladen Gogala wrote:
>> > >
>> > > Why is it that I can't get a response to my question: when will
>> > > DBD::Oracle fully support Oracle's array interface?
>> >
>> > I don't get paid to work on DBD::Oracle. It's a hobby, and one that
>> > generally gives me far more headaches than it could possibly be worth.
>> >
>> > Patches welcome. Volunteers to help maintain it also welcome.
>> > Take your pick.
>> >
>>
>> I for appreciate your work on DBI/DBD! I have been working with
>> DBD::Oracle for a few years now, and I am not 100% certain what is
>> being requested? What part isn't supported?
>
> Use of the array interface isn't supported. If I do bind_param_array and
> execute_array
> DBD::Oracle will break it into single step executions. Recently, I had to
> load a file
> of 20,000,000 records into a database. I wrote a perl script using
> bind_param_array and
> execute_array and it worked much slower then anticipated. The reason was
> the array interface.
> I had to re-write the file itself into a format that could be used by SQL
> Loader and
> re-do the job. Perl DBI isn't very useful as a loading tool without the
> support for the
> array interface.
>
>
>>
>> --
>> C Wayne Huling
>>
>>
>
> --
> Mladen Gogala
> http://www.mgogala.com
>
>
Hi
I have used DBI/DBD::Oracle for many years, but I would not dream of using
it to batch load 20 million rows.
Oracle recommends the use of sqlldr for large batch loads, and if
performance is critical use the the DIRECT option. If the data is more
complicated, pre-process using a local perl script then use sqlldr, or
load the data into some work tables and use a pl/sql procedures to process
the data.
All the best
Simon