Results grid limited to 5000 rows?

224 views
Skip to first unread message

storri

unread,
Jan 5, 2007, 12:02:33 PM1/5/07
to Visual Log Parser
Is the rowlimit of the results grid configurable?

If not, can you increase the limit to 50000 rows perhaps?

Thanks,
Simon

ps Great tool, just discovered and started exploring it
today............. :-)

Charlie Arehart

unread,
Jan 5, 2007, 12:30:05 PM1/5/07
to visual-l...@googlegroups.com
Welcome to the wonderful world of LogParser, Simon. As for your question, I
don't think there is one (the docs refer only to the RTP parm for
controlling how many to show per screen).

Instead, though, this is where you can rely on SQL to control what goes INTO
the grid. Consider the TOP nn directive (as in SELECT TOP 50000 ...). Check
out the docs and do a search on TOP. The first two entries explain it and
show examples.

/Charlie

storri

unread,
Jan 6, 2007, 5:13:06 AM1/6/07
to Visual Log Parser
Thanks for the quick reply.
I'd already tried the TOP command but despite setting it to 10000 the
rows in the grid (and the text on the Messages tab for ROWS AFFECTED)
are still limited to 5000.
Might there be a hardcoded TOP clause in the program?
Simon

> :-)- Hide quoted text -- Show quoted text -

Charlie Arehart

unread,
Jan 6, 2007, 10:20:52 AM1/6/07
to visual-l...@googlegroups.com
Ah, sorry. I missed that you were wanting to show *more*. My apologies.

This is interesting. I find no reference in the docs or in a google search
to anything related to a 5000 row limit. Perhaps someone else will chime in.

/Charlie
http://www.carehart.org/blog/

onerror

unread,
Feb 23, 2007, 8:12:23 AM2/23/07
to Visual Log Parser
Hello
Is there a solution to this problem yet?

/Anders

On 6 Jan, 16:20, "Charlie Arehart" <char...@carehart.org> wrote:
> Ah, sorry. I missed that you were wanting to show *more*. My apologies.
>
> This is interesting. I find no reference in the docs or in a google search
> to anything related to a 5000 row limit. Perhaps someone else will chime in.
>

> /Charliehttp://www.carehart.org/blog/

>
>
>
> -----Original Message-----
> From: visual-l...@googlegroups.com
>
> [mailto:visual-l...@googlegroups.com] On Behalf Of storri
> Sent: Saturday, January 06, 2007 5:13 AM
> To: Visual Log Parser
> Subject: Re: Results grid limited to 5000 rows?
>
> Thanks for the quick reply.
> I'd already tried the TOP command but despite setting it to 10000 the rows
> in the grid (and the text on the Messages tab for ROWS AFFECTED) are still
> limited to 5000.
> Might there be a hardcoded TOP clause in the program?

> Simon- Dölj citerad text -
>
> - Visa citerad text -

Charlie Arehart

unread,
Jul 27, 2007, 12:35:39 PM7/27/07
to visual-l...@googlegroups.com

Anyone know if there's a discussion group about log parser itself (not the
visual product of this list)?

There used to be a logparser.com site, but it seems to have vanished.

/charlie

Brian

unread,
Jul 27, 2007, 2:51:34 PM7/27/07
to visual-l...@googlegroups.com
yes, the logparser site is indeed gone :(
i wish there was another group or forum, but i havent found one yet.

and this visual log parser group seems to be dead also. nobody ever replies anymore

jake

Charlie Arehart

unread,
Jul 27, 2007, 5:32:58 PM7/27/07
to visual-l...@googlegroups.com
I can report some good news, since I last wrote. As you may notice, the old logparser.com site redirects to iis.net. Well, I found a very recent discussion thread acknowledging the move with a suggestion that they are working on migrating the old site content in:
 
 
In a comment there, I just asked if they could create the forums sooner rather than later.
 
BTW, I also point out there a link to the fabulous archive.org pages holding a point in time snapshot of the old logparser site from just a couple months ago. Plenty of good content accessible there, though not the old forum content.
 
/charlie
 


From: visual-l...@googlegroups.com [mailto:visual-l...@googlegroups.com] On Behalf Of Brian
Sent: Friday, July 27, 2007 2:52 PM
To: visual-l...@googlegroups.com
Subject: Re: Anyone know if there's a discussion group about log parser itself (not the visual product of this list)?

Reply all
Reply to author
Forward
0 new messages