SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Member
    Join Date
    May 2004
    Location
    blore
    Posts
    1
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    How long doest it take to insert 100MB datas in PHP

    Hi,

    I wrote a php program to read and parse apache log file.The size of the log file is 100MB.

    From that i collected 70MB datas.

    I tried to insert this data into mysql database ,it takes hardly 15 minutes to finish the job.

    Is this timing is correct?

    or

    ist possible to reduce the time?


    please help me..........

    Thanks
    Perumal.

  2. #2
    AdSpeed.com Son Nguyen's Avatar
    Join Date
    Aug 2000
    Location
    Silicon Valley
    Posts
    2,241
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Probably you need to provide more details (the schemas, how you parse/import the rows) for anyone to help. W/o the info, I'd say 15mins for about 100Mb is inefficient.
    - Son Nguyen
    AdSpeed.com - Ad Serving and Ad Management Made Easy


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •