I am on a server with a limit of 72,000 queries per hour..
If I have a script running as a cronjob / Scheduled task, every 5
minutes, is it safe to do the following :-
while ($x<100){
$query = "INSERT INTO Events VALUES ('',$text)";
$result=mysql_query($query) or die( "Unable to view data\n" . mysql_error());
etc...
$x++;
}
is it safe to do this - all within a single script ?
NOTE1 :- I'll change the values to be inserted - within the while loop
- Im not inserting the same values :)
NOTE 2:- I havn't timed it yet (using MYSQL), but an average script
using flat-text based output files - 'inserting' 4 lines of data,
takes 1-2 seconds...
QUESTION:
Is it safe to do the above - insert 100 values at once into a master
table / index - & then no action for 3-4 minutes till the next cron
cycle ?
--
G
NZ community groups - [EMAIL PROTECTED]
NZ-Website space offered.
Community email addresses:
Post message: [email protected]
Subscribe: [EMAIL PROTECTED]
Unsubscribe: [EMAIL PROTECTED]
List owner: [EMAIL PROTECTED]
Shortcut URL to this page:
http://groups.yahoo.com/group/php-list
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/php-list/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
