Posted by Glenn on 04/09/07 21:50

On Sun, 08 Apr 2007 22:09:51 +0100, Andy Hassall <andy@andyh.co.uk>
wrote:

>On Sun, 08 Apr 2007 18:25:41 GMT, Glenn <bagsmode@frontiernet.net> wrote:
>
>>I'm using Apache server, PHP (ver4) driven pages, querying a MySQL DB.
>>I'm trying to monitor/tail
>>some log files and perform queries to
>>1) insert the new data,
>>2) verify that the data is within certain constraints.
>>
>>Each query is taking a full second to perform (is that normal? I have
>>about 100k records at the moment).
>
> "Normal" depends on how much work you're doing on the data - just a number of
>rows isn't enough to say.

Yeah, I'll have to say that I have about 5 SUM's in the Select
statement :D prolly helping the slowdown, eh?

>>Plus, having an issue with only able to tail two files...?
>>I can open two Internet Explorer windows and tail two files; but as
>>soon as I try to open a 3rd, nothing happens until I get out of one of
>>the others.
>>
>>Any idea to why I can only do 2 at a time?
>
> Browsers will only open a limited number of connections to a server at the
>same time, to avoid thrashing the server. You're most likely seeing this limit.
>How are you handling this - outputting data as it appears in the logfile, but
>keeping the same HTTP connection open and flushing? That will hit the
>connections limit.

Yes: "outputting data as it appears in the logfile, but
keeping the same HTTP connection open and flushing? "

> An alternative is to have the browser poll the page for new information, e.g.
>with a refresh header (or meta refresh equivalent), or Javascript timer.

Was hoping to do this in the next version.. glad that you mentioned
it, so that I know that I'm going decent direction :)

>Andy Hassall :: andy@andyh.co.uk :: http://www.andyh.co.uk
>http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool

Thanks
Glenn

[Back to original message]