I've been using the default RedHat 9 MySQL installation for a while now - and it's been running great, nice and fast even from remote connections.
When trying to implement a heirarchal category database - I ran across some SQL I could not do because of my version (namely subqueries).
So I went and got 4.1.14-standard version and upgraded. Now local queries (php from localhost) run very fast, however scripts on other servers that accessed it would run rather slow. I've narrowed it down to being really slow in creating the connection to the database. I'm using an IP to create the connection. I've also noticed this remote slowing occuring with the ODBC adapater from a VB.NET program.
Any ideas on how to get this back to the speed it used to be -without of course losing my ability to subquery?
When trying to implement a heirarchal category database - I ran across some SQL I could not do because of my version (namely subqueries).
So I went and got 4.1.14-standard version and upgraded. Now local queries (php from localhost) run very fast, however scripts on other servers that accessed it would run rather slow. I've narrowed it down to being really slow in creating the connection to the database. I'm using an IP to create the connection. I've also noticed this remote slowing occuring with the ODBC adapater from a VB.NET program.
Any ideas on how to get this back to the speed it used to be -without of course losing my ability to subquery?