homepage Welcome to WebmasterWorld Guest from 54.204.141.129
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Pubcon Platinum Sponsor 2014
Home / Forums Index / Code, Content, and Presentation / PHP Server Side Scripting
Forum Library, Charter, Moderators: coopster & jatar k

PHP Server Side Scripting Forum

    
php mysql blob problem
problems inserting file into db
copongcopong




msg:1268146
 7:36 pm on Dec 17, 2003 (gmt 0)

i'm having problems inserting a long list of data (a file with 20,000+ lines) into a db (mysql) as a long blob or blob.

if use php's feature to count the number of lines of the file using explode, it still returns the exact lines (20,000+) but if it gets to the part when putting it into the db, it cuts the lines into 3,000+ lines only.

I cannot detect if the problem is with php or mysql.

help!. thanks. =)

 

bcolflesh




msg:1268147
 10:32 pm on Dec 18, 2003 (gmt 0)

What is your script execution timeout set to on the server?

panic




msg:1268148
 10:41 pm on Dec 18, 2003 (gmt 0)

Try dumping the output into a text file, and that way, you can determine wether it's PHP or MySQL.

copongcopong




msg:1268149
 2:54 am on Dec 20, 2003 (gmt 0)

The script execution time is 60 sec in php, however, when I try to put the webserver and mysql to a zeon machine, the problem was solved. (?!?) the previous machine that is having the problem is celeron. Hardware problem or configuration?

thanks.

panic




msg:1268150
 5:36 am on Dec 20, 2003 (gmt 0)

The script execution time is 60 sec in php, however, when I try to put the webserver and mysql to a zeon machine, the problem was solved. (?!?) the previous machine that is having the problem is celeron. Hardware problem or configuration?

Well, if it's executed on a box with a faster processor, the process time will be shorter (and will probably be under 60 seconds)

copongcopong




msg:1268151
 5:43 am on Dec 21, 2003 (gmt 0)

Thanks.

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / PHP Server Side Scripting
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved