« Previous Next »

Thread: Slow Parsing

Last post 02-05-2007 6:03 AM by LogParser User : Suresh. 0 replies.

Average Rating Rate It (5)

RSS

Page 1 of 1 (1 items)

Sort Posts:

Shortcuts

Search | Active Posts | Unanswered Posts | View all users

  • 02-05-2007, 6:03 AM

    Slow Parsing

    Reply Contact

    I am trying to upload the IIS log file to SQL SERVER. In one scenario log parser takes around 2 hours to upload records of 1.5 million. Is it expected behaviour? Because in previous parsing in took less than 1 min to upload 50,000 records.

    Below is the code for upload

    "c:\program files\log parser 2.2\logparser.exe" "SELECT cs-uri-stem,date,time,c-ip,cs-uri-query,cs(cookie) INTO IISLog_Temp  FROM %1 WHERE cs-uri-stem in ('/Test1.aspx';'/Test1.aspx') " -i:IISW3C -o:SQL -database:TEST

    Thanks in advance.

    Regards

    Suresh
    Tags:
Page 1 of 1 (1 items)
Microsoft Communities