"Five Cats" <ca*******@[127.0.0.1]> wrote in message
news:KW**************@[127.0.0.1]...
In message <OQ*****************@newssvr27.news.prodigy.com> , JimC
<ji**@cross-comp.com> writes
"JimC" <ji**@cross-comp.com> wrote in message
news:8d****************@newssvr27.news.prodigy.co m... I have PHP installed on a Windows XP platform using IIS as
server. When updating a MySQL database field set to MEDIUMTEXT
in phpMyAdmin, the transaction seems to fail if the text contains
more than a few hundred characters.
The update is actually made successfully, but afterwards, the server
cannot locate the phpMyAdmin page as requested by the client
browser. I get a "Page cannot be found" error. Clicking
on Update from the browser clears the problem.
Anyone know what's causing the problem? Potential sources
of the problem could be with the driver for MySQL, with the IIS
settings, or with the phpMyAdmin settings. I suspect IIS.
Still having problems with this. As I update my local MySQL database,
it brings the system practically to a halt. It is probably not PHP-
related, but does anyone recognize the problem?
What happens if you run the same SQL directly? I bet it freezes then as
well, and if it does this suggests there is a problem in MySQL not
anywhere else.
Let me clarify. I can read and write from a MySQL database in normal
time using PHP calls in my own program , and a benchmark test I run now
and then performs as expected. I could beat it down further by using
C language calls. I've played this game before.
But updating through phpMyAdmin to a page served by IIS is what runs
slowly. It almost hangs on a single transaction, which is bizarre since
it's going through the same driver that my PHP applcation script uses.
Of course it's not exactly the same, i.e., the phpMyAdmin doesn't operate in
exactly the same environment as my PHP application. But I sort of
suspect that's where the problem lies.
--
Anyway, if anyone has nothing else to do, take the California quiz, another
PHP app, at
http://cross-comp.com/pages/webdesig.../califquiz.php
Jim