|
|
Posted by Glenn on 04/07/07 20:44
On Fri, 02 Feb 2007 16:45:43 +0100, Michael Fesser <netizen@gmx.de>
wrote:
>.oO(petersprc)
>
>>In all likelihood you won't notice any difference in performance,
>>though PHP5 is supposed to be faster in certain areas. I would suggest
>>building your site, and then trying to optimize any bottlenecks such
>>as database access. For instance, cutting down on unnecessary round-
>>trips to the database, and perhaps using persistent connections.
>
>Depends on the server. Connecting to a MySQL server for example is
>pretty cheap, while persistent connections may cause you a lot of
>troubles. Don't do that unless you really need it and know what you're
>doing.
>
>Micha
I think this might be a problem I'm having. 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.
I'm not closing the connections, I'm guessing this would be considered
persistent (just to make sure I'm understanding--not a big DB guy)?
I just didn't want to keep openning and closing connections.
Each query is taking a full second to perform (is that normal? I have
about 100k records at the moment).
Plus, having an issue with only able to tail two files...?
I'm using Apache server, PHP (ver4) driven pages, querying a MySQL DB.
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?
Thanks
Glenn
Navigation:
[Reply to this message]
|