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
(thinking…)
Password icon
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
(thinking…)
Password icon
Signed in as (Sign out)
Submitting...

Feedback and Knowledge Base