Well for whatever the reason it's just not working because there are too many stocks in the stocktrader table in the database... (currently at 412 entries)... when I delete them down to about 300 or less it runs fine... somwhere are 350 entries it just doesn't run at all (or at least it just doesn't do the correct calculations). I don't think it's a bad stock symbol or such because I visually checked the table, it all looks well, and it doesn't matter which stocks I delete, as long as I get that table below a certain size it will work.
I checked the php settings on max execution time and such, but I can't change the settings on my hosting plan at the moment- but in either case ~400 stocks shouldn't really time out I don't think.
I'm wondering if the cron job file can be edited to run a 100 to 200 operations at a time and repeat until its finished? I will look at it but honestly that is probably above my skill level.
How many stocks do the people that have this working have in their databases?
|