|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
[2003-07-10 12:01 UTC] sniper@php.net
|
|||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Mon Dec 08 03:00:02 2025 UTC |
Description: ------------ I am trying to do a batch insert to a MySQL database. There are rouhyly 78,000 inserts to complete however my script will only insert 65,534 at any one time. I am running the script using the CLI method - it does not time out but prodces the message 'Segmentation Fault' after doing the 65,534 entries. I am not sure of the significance it being the highest 16- bit no. If you need full source code + database structure please let me know and I will put in public where you can download. Apologies if this is a know MySQL problem - I couldn't see any explanations from this point of view. Reproduce code: --------------- Basically While ( eof ) // Read File // If certain conditions $insertSQL = "INSERT INTO entry VALUES ('', '$ip', '$user_name', '$new_date_time', '$new_url', '', '$code') "; //echo $insertSQL . "<br>"; $run = mysql_query($insertSQL); Expected result: ---------------- Zero Output Actual result: -------------- Segmentation fault