u2xs

I'm running a data mining software that can return anywhere between 1 and 100 results. Through this HTTP method, I'm noticing that my server does not process the request if the URI is longer than 2000 characters. For whatever reason, at 1000 characters, it stopped showing an error message, but the multiple insert commands were not actually inserting into the db. When I broke it down to unique requests, it did work. My only concern was that it might affect the server/db adversely due to it's volume. I appreciate the concern. Thanks. Ahh, that makes sense to me, thanks

I use PHP to bridge between an obscure programming language (AutoHotKey) and a MySQL backend. This leads me to 2 questions 1) Should I be concerned about latency? There are times that I have to make a few hundred inserts at a time and then there's only a short pause before a few hundred more inserts. 2) I'm using a system that seems like it's not the best way to use PHP to bridge the gap. I use HTTP encoded URLs to get & set information. So this query would translate into that URL. Is there a better way with PHP? INSERT INTO testTable (id, channel, status, datetime) VALUES ('1', '23', '3', NOW()); http://Mywebsite.com/php/ahk2sql.php?key=01010AuthenticationKey0101010&query=INSERT%2520INTO%2520testTable%2520%28id%2C%2520channel%2C%2520status%2C%2520datetime%29%2520VALUES%2520%28%271%27%2C%2520%2723%27%2C%2520%273%27%2C%2520NOW%28%29%29%3B