Re: DBD::Oracle very slow fetch via a function returned cursor

2009-01-15 Thread scoles
Hi Martin I think I found the root cause. In 1.22 support for auto select of lobs was added, and when you have a lob in a ref_cursor you can only select 1 row. hence the is_child. What I will do it try to set it up so the is_child it only set when there is a Lob in select. Will get back to you

Re: DBD::Oracle very slow fetch via a function returned cursor

2009-01-15 Thread Martin Evans
sco...@pythian.com wrote: Hi Martin I think I found the root cause. In 1.22 support for auto select of lobs was added, and when you have a lob in a ref_cursor you can only select 1 row. hence the is_child. What I will do it try to set it up so the is_child it only set when there is a Lob in

DBD::Oracle very slow fetch via a function returned cursor

2009-01-14 Thread Martin Evans
Hi, I have a strange situation I would dearly like some help with as I have now come unstuck trying to understand what the code in oci8.c is supposed to do. I have one table and 2 ways to select the same data from it but one is fast and the other is really slow but I'm stuck with the latter.

Re: DBD::Oracle very slow fetch via a function returned cursor

2009-01-14 Thread John Scoles
Great stuff Martin I did not write the ref_cursor code but I have an idea hat the fect rows satamet might be getting all of the rows each times it runs. You are right that there should be some sort of ability to set the size of the records returned in this function. I'll try to have a look

Re: DBD::Oracle very slow fetch via a function returned cursor

2009-01-14 Thread Martin Evans
John Scoles wrote: Great stuff Martin I did not write the ref_cursor code but I have an idea hat the fect rows satamet might be getting all of the rows each times it runs. You are right that there should be some sort of ability to set the size of the records returned in this function.

Re: DBD::Oracle very slow fetch via a function returned cursor

2009-01-14 Thread Martin Evans
John Scoles wrote: Great stuff Martin I did not write the ref_cursor code but I have an idea hat the fect rows satamet might be getting all of the rows each times it runs. You are right that there should be some sort of ability to set the size of the records returned in this function.

Re: DBD::Oracle very slow fetch via a function returned cursor

2009-01-14 Thread Martin Evans
Martin Evans wrote: John Scoles wrote: Great stuff Martin I did not write the ref_cursor code but I have an idea hat the fect rows satamet might be getting all of the rows each times it runs. You are right that there should be some sort of ability to set the size of the records returned in

Re: DBD::Oracle very slow fetch via a function returned cursor

2009-01-14 Thread Martin Evans
Martin Evans wrote: Martin Evans wrote: John Scoles wrote: Great stuff Martin I did not write the ref_cursor code but I have an idea hat the fect rows satamet might be getting all of the rows each times it runs. You are right that there should be some sort of ability to set the size of