By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,077 Members | 1,237 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,077 IT Pros & Developers. It's quick & easy.

using clob in where clause

P: n/a
Hi everyone,

I am a developer working on php with oracle as backend.
I am facing a problem related with the CLOB data.
The problem is as follows
My application uses a table which contains Clob datatype.
I need to do a search on this table based on the clob data,i.e., I am
using the column which is a clob datatype in the where clause.
The query is as follows
" select * from mytable where (dbms_lob.instr(mybody, 'as') > 0)"
If the result set has less records then the data gets displayed in the
front end page of the application...
If the result set contains more records and the query takes more that
30 seconds to execute in the backend the data does not get displayed in
the frontend page of the application.
I get an error telling
"Fatal error: Maximum execution time of 30 seconds exceeded."
Can any one of you please help me out in solving this problem.

Thanks in advance.

Mar 1 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
If the result set contains more records and the query takes more that
30 seconds to execute in the backend the data does not get displayed in
the frontend page of the application.
I get an error telling
"Fatal error: Maximum execution time of 30 seconds exceeded."
Can any one of you please help me out in solving this problem.


set_time_limit(0);

See <http://www.php.net/set_time_limit>.

---
Steve

Mar 1 '06 #2

P: n/a
On 1 Mar 2006 04:20:42 -0800, gu**********@googlemail.com wrote:
I am a developer working on php with oracle as backend.
I am facing a problem related with the CLOB data.
The problem is as follows
My application uses a table which contains Clob datatype.
I need to do a search on this table based on the clob data,i.e., I am
using the column which is a clob datatype in the where clause.
The query is as follows
" select * from mytable where (dbms_lob.instr(mybody, 'as') > 0)"
If the result set has less records then the data gets displayed in the
front end page of the application...
If the result set contains more records and the query takes more that
30 seconds to execute in the backend the data does not get displayed in
the frontend page of the application.
I get an error telling
"Fatal error: Maximum execution time of 30 seconds exceeded."
Can any one of you please help me out in solving this problem.


Querying the contents of a CLOB like this involves full table scans, and even
worse, accessing all of each of the CLOBs. This is expensive, and will
inevitably take a long time.

If you want to query for text within a CLOB more quickly, you should probably
consider using Oracle Text.

Follow-ups set to comp.databases.oracle.server.

--
Andy Hassall :: an**@andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool
Mar 1 '06 #3

P: n/a

Steve wrote:
If the result set contains more records and the query takes more that
30 seconds to execute in the backend the data does not get displayed in
the frontend page of the application.
I get an error telling
"Fatal error: Maximum execution time of 30 seconds exceeded."
Can any one of you please help me out in solving this problem.


set_time_limit(0);

See <http://www.php.net/set_time_limit>.

---
Steve


Hi Steve,

Thanks a lot for the help u provided me...
I copied set_time_limit(0) in the php file that was displaying the
search results and all worked fine...
Now the page is not breaking....

Harika

Mar 2 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.