Jump to content

Archived

This topic is now archived and is closed to further replies.

DaVuLf

Fatal Error: Time over 30seconds... Hmm...

Recommended Posts

I've just recently started getting this error, so I'm not quite sure what is up. I'm not going to post the code since it is 352 lines and will not fit. Instead, here is the link to download the php file.

[a href=\"http://www.briancomeau.net/wdt/insert.php\" target=\"_blank\"]FILE[/a]

I get the following error:
[code]
Fatal error: Maximum execution time of 30 seconds exceeded in /home/content/b/r/i/briancomeau/html/wdt/insert.php on line 225
[/code]

I think it means that I have too much going on, but I'm not really sure how to reduce this. Any help would be appreciated.

Share this post


Link to post
Share on other sites
I was about to say that it's probably a select query that takes too long to run, but it seems like an insert page. Hard to say... what types of SQL statements are you running?

Share this post


Link to post
Share on other sites
[!--quoteo(post=377684:date=May 27 2006, 07:52 PM:name=fenway)--][div class=\'quotetop\']QUOTE(fenway @ May 27 2006, 07:52 PM) [snapback]377684[/snapback][/div][div class=\'quotemain\'][!--quotec--]
I was about to say that it's probably a select query that takes too long to run, but it seems like an insert page. Hard to say... what types of SQL statements are you running?
[/quote]

Take a look at the file, it should be pretty self explanatory.

I run about.. 15 different queries within the file. I update/select 3 different tables.

Share this post


Link to post
Share on other sites
Was an infinate loop within a 'for'. Here is another question. Why does MySQL sort like this:

[code]
name         value         balance         worth Descending         id
Brian      0     97706.8     97706.8     22
Wussie     0     117717.75     117717.75     18
Woo      0     107069.14     107069.14     21
Team1     0     106361.44     106361.44     17
Paco       0     103765     103765     19
Taco       0     102943.42     102943.42     20
[/code]

So.. It's sorted Descending, but the 97706.8 is on top. I tried re-sorting, or tried by ascending, but that number is always in the wrong place.

Any ideas?

Thanks,
DaVuLf

Share this post


Link to post
Share on other sites
Well, it seems that my Googling has once again paid off. The solution was to make sure my field was a DOUBLE (was varchar). Works now :).

Share this post


Link to post
Share on other sites
DOUBLE? Sounds like you should be using DECIMAL -- no need to have that much precision for what seems like a currency field.

Share this post


Link to post
Share on other sites
[!--quoteo(post=377884:date=May 28 2006, 01:30 PM:name=fenway)--][div class=\'quotetop\']QUOTE(fenway @ May 28 2006, 01:30 PM) [snapback]377884[/snapback][/div][div class=\'quotemain\'][!--quotec--]
DOUBLE? Sounds like you should be using DECIMAL -- no need to have that much precision for what seems like a currency field.
[/quote]

Didn't know there was such a field. Double is to 16 places, right? Isn't it the slightly less precise version of Float?

I can't remember these things from when I used to write Java last year. [img src=\"style_emoticons/[#EMO_DIR#]/huh.gif\" style=\"vertical-align:middle\" emoid=\":huh:\" border=\"0\" alt=\"huh.gif\" /]

[b]Edit:[/b] Can I store a Double number (ie, more than 2 decimals) in a Decimal field? If so, does it just truncate the rest of the numbers? Otherwise, is there a toDecimal ($var); type code somewhere? Also, is there really a difference... I mean, I don't really have a problem with it being in Double, but if it saves space or something, then I might change.

Thanks!

Share this post


Link to post
Share on other sites
There are different storage requirements -- see [a href=\"http://dev.mysql.com/doc/refman/5.0/en/storage-requirements.html\" target=\"_blank\"]here[/a].

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.