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