Storing queries

2003-04-03 Thread H. Scott Brown
Hi, List, Just wondering... Anybody have a good method to store queries? I know MySQL doesn't support stored procedures at this time (will in 5.x, I guess). Obviously, I can just stash it in a varchar field in a table somewhere, then select it and execute it in a separate query, but is there

MySQL table locking?

2003-02-12 Thread H. Scott Brown
Hello, list, I'm having a weird issue with table locking. I'm running MySQL 3.23 on a Win2k server, used for eCommerce applications. All settings appear to be in order, that is, KeepAlive is 30, connection pooling is on, with a timeout of 30. The tables in any given database seem to remain loc