Well, we figured out. Jochem, thanks for your input... a few minutes
too late! =D We discovered that it *was* timing out at 30 seconds,
which is how it was set in the php.ini file. We upped that and now it
works.
THANKS!!
~Philip
On Jul 25, 2006, at 3:34 PM, Jochem Maas wrote:
Philip Thompson wrote:
Hi all.
I have a list of people in a database who live in particular
rooms. Next
lucky them, back when I was a kid you were lucky if you had a
cardboard box,
and a wet one at that.... ok let's not go down that road ;-)
semester, they may live somewhere else, so I need to update my
database.
(I know the data becomes stale, but not that often.) Here's what I'm
doing to update:
1. Pull list of IDs from database A - store in array
2. Foreach ID in array, search database B to see if they have a
new room
2a. If no, go back to step 2 and go to next ID
3. Compare new room to current room
3a. If different, update the record to new room
That's basically it. Now, I know this works (sorta) because the
records
are updating with the appropriate information. Here's the problem I'm
running into: it only does a certain amount and then quits!! WHY!!?!
your script is timing out. search this lists archive, the web and
the manual
for more info.
AND THEN ... assuming your script is not fundamentally flawed (i.e
there is not a way
you could do what you want much faster and with *way* less
queries) ...
go make your update script to work as a cmdline script (so it works
from the cmdline
rather than being called from the browser);
basically it sounds like what you want to do could more suitably
considered
as 'offline' processing - something you shouldn't be triggering
from a http request.
(cmdline scripts don't timeout by default, where as scripts run via
http do -
you can force scripts run via http to keep going but if you need to
do that there is
something wrong - any script run via web request should finish in a
few seconds at most)
The total number of records I have is 1335 - pulled from step 1.
However, when I go through the list and query for new rooms, it
stops...
randomly... not even at the same record each time. Sometime it's 230,
sometimes it's 476 - truly random from what I can tell. I am
sorting the
query (ORDER BY) each time, so I know it's the same order.
Any thoughts on why this is happening? Possibly a buffer issue?
Thanks in advance.
~Philip
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
