I suggest you ...

Stop it running out of memory when plenty of RAM free

Stop it running out of memory when plenty of RAM free

1 vote
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Matthew Phillips shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
    declined  ·  AdminLizard Labs (Admin, Lizard Labs) responded  · 

    LPL tries to store all the data in the memory before displaying it bit also LPL runs in 32 bit mode (even on 64 bit systems) so it has limited available memory.

    But the common use case for LPL is not to store entire logs in memory and display the log lines. Browsing trough thousands of files is not very practical. You can narrow your output using WHERE and/or GROUP BY and browse this small dataset. The queries are also much faster when the output is smaller. For instance, try to see if LPL works by writing some query like:

    SELECT TOP 1000 * FROM ‘c:\log\*.log’

    This will limit the output to 1000 records and start from there.

    or

    SELECT Count() FROM ’c:\log\.log’

    This will go trough all files (the size is not important) and will count the lines.

    I hope this was helpful, and you will find LPL useful the way it is now.

    0 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...

      Feedback and Knowledge Base