Frank Rocco
|
Posted: 07/10/2002, 6:15 AM |
|
Fatal error: Maximum execution time of 30 seconds exceeded in
d:\inetpub\wwwroot\is\rad\db_odbc.inc on line 78
I am trying to query a database on an AS/400 system using ODBC.
Is there a setting I can change to resolve this?
Also, is there anything I can do to improve speed?
Using CC2 & PHP
Thanks
Frank
|
|
|
Frank Rocco
|
Posted: 07/10/2002, 8:16 AM |
|
I found the answer using set_time_limit()
|
|
|
Christoph Grottolo
|
Posted: 07/10/2002, 11:53 AM |
|
Hi
Frank Rocco wrote:
> I found the answer using set_time_limit()
But you still don't have better performance. We also have serious
performance issues with PHP, DOBC and MSSQL.
Christoph
|
|
|
RonB
|
Posted: 07/10/2002, 1:21 PM |
|
Do you use persistent connections? Getting a connection is taking up a lot
of time. With oracle it sometimes makes a difference of seconds.
I must say that mysql is the fastest of the three dtabases we have at my
company(Oracle, Solid, MySQL).
MySQL/PHP is the fasted combination I have seen so far.
RonB
"Christoph Grottolo" <cg@gordimer.net> schreef in bericht
news:aghvqp$g6p$1@news.codecharge.com...
> Hi
>
> Frank Rocco wrote:
> > I found the answer using set_time_limit()
>
> But you still don't have better performance. We also have serious
> performance issues with PHP, DOBC and MSSQL.
>
> Christoph
>
|
|
|
Headhunter
|
Posted: 09/11/2002, 3:06 PM |
|
Uptimize your database. You have to create indexes on the colums you are
"selecting" (queriïng) on.
"RonB" <r.borkent@123chello.nl> wrote in message
news:agi504$pob$1@news.codecharge.com...
> Do you use persistent connections? Getting a connection is taking up a lot
> of time. With oracle it sometimes makes a difference of seconds.
> I must say that mysql is the fastest of the three dtabases we have at my
> company(Oracle, Solid, MySQL).
> MySQL/PHP is the fasted combination I have seen so far.
>
> RonB
>
> "Christoph Grottolo" <cg@gordimer.net> schreef in bericht
>news:aghvqp$g6p$1@news.codecharge.com...
> > Hi
> >
> > Frank Rocco wrote:
> > > I found the answer using set_time_limit()
> >
> > But you still don't have better performance. We also have serious
> > performance issues with PHP, DOBC and MSSQL.
> >
> > Christoph
> >
>
>
|
|
|
|