chemo37
Posts: 4
|
| Posted: 03/07/2007, 9:44 PM |
|
Hi
many times when i process a page generated with CCS give me a result that error message
Fatal error: Maximum execution time of 30 seconds exceeded in C:\Ocef\webocef\ECuentasRes.php on line 838 ....
what could i do
Regards
Guillermo
_________________
Guillermo Aguilar |
 |
 |
mamboBROWN
Posts: 1713
|
| Posted: 03/08/2007, 1:33 PM |
|
chemo37
Exactly what is the page doing (is it a report or is it processing a large amount of data)?? We need more information...
|
|
|
|
chemo37
Posts: 4
|
| Posted: 03/19/2007, 8:52 PM |
|
Hi ManboBrown ...im processing a large mount of data via SQL Sentence and give me a next message "Fatal error: Maximum execution time of 30 seconds exceeded in C:\Ocef\distribuyeEXC.php on line 1110" sometimes give me a error message in Template.php on line 292 for example ....
My instruction in SQL is
SELECT *
FROM (distribuye LEFT JOIN doctipo ON
distribuye.rec_tipdoc = doctipo.tipodoc) INNER JOIN tbl_dependencias ON
distribuye.rec_idcoddep = tbl_dependencias.dep_idsubdep
WHERE ( distribuye.rec_fecha >= '{s_rec_fecha}'
AND distribuye.rec_fecha <= '{e_rec_fecha}' )
AND distribuye.rec_idcoddep LIKE '{xsdep}%'
ORDER BY rec_fecha, distribuye.rec_tipdoc, distribuye.rec_docum
and the table have about 23500 records in MySQL
Regards
_________________
Guillermo Aguilar |
|
|
|
mamboBROWN
Posts: 1713
|
| Posted: 03/20/2007, 2:19 PM |
|
chemo37
Try running your query with the MySQL command: EXPLAIN SELECT select_options on the MySQL server and see what your results are. With the help of EXPLAIN, you can see when you must add indexes to tables to get a faster SELECT that uses indexes to find records.
|
|
|
|
chemo37
Posts: 4
|
| Posted: 03/21/2007, 6:08 PM |
|
Im indexed the table with sugestions made by command EXPLAIN but i dont have good results ... i dont know how to do ...and solve the problem...
Thanks
CHemo37
_________________
Guillermo Aguilar |
|
|
|
mamboBROWN
Posts: 1713
|
| Posted: 03/22/2007, 5:40 PM |
|
chemo37
Can you show us the results of the EXPLAIN Select?? Also, can you show us all of the fields specific to the tables included in your query above (Please include the Primary and or Foreign Keys)??
|
|
|
|
chemo37
Posts: 4
|
| Posted: 03/22/2007, 8:45 PM |
|
Hi ManboBrown
I found the solution ...finally i discover that CCS is not the problem ...change the section in php.ini
;;;;;;;;;;;;;;;;;;;
; Resource Limits ;
;;;;;;;;;;;;;;;;;;;
max_execution_time = 16000 ; Maximum execution time of each script, in seconds
max_input_time = 480 ; Maximum amount of time each script may spend parsing request data
memory_limit = 32M ; Maximum amount of memory a script may consume (8MB)
it works !!!!
Thanks for your support
Chemo37
_________________
Guillermo Aguilar |
|
|
|
J_T
Posts: 8
|
| Posted: 12/12/2007, 4:02 AM |
|
Help!!!
I've got a similar problem, but cant find the php.ini file?
would the resources section be under any other file name?
Thanks
|
|
|
|
Oper
Posts: 1195
|
| Posted: 12/12/2007, 4:38 AM |
|
J_T
normaly located c:\programfiles\mysql\server...... (somthing like that)
_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)
http://www.PremiumWebTemplate.com
Affiliation Web Site Templates
Please do backup first |
|
|
|
