"Celona, Paul - AES" <[EMAIL PROTECTED]> wrote on 06/03/2005 01:03:18 PM:
> I am running mysql 4.0.18 on Windows 2003 server which also hosts my > apache tomcat server. My applet makes a connection to the mysql database > on the server as well as a socket connection to a service on the same > server. In the lab with only a hub between the client and server, the > application performs well and data is transferred quickly. In the > deployed environment with a pair of gateways in between, socket > performance is not affected much, but the application gui bogs down on > the database queries. Performance is so slow that some simple GUI > updates take up to 5-7 seconds with only a simple 1 table update > occurring. > > Does anyone have experience with this and/or can provide some insight? It sounds like you don't have all of your indexes declared on your production database. There could also be an issue of network lag between your application server and your database server. The best performing applications use the fewest trips to the database to accomplish what they need. You may want to examine your application design and minimize the number of trips you make to the server. For example, assume you run two queries, one to get a list of departments and another to list the people in each department. If you design your application to perform one lookup to get the departments list then loop through that list to find the department's people, you are making way too many "trips" to the database. A more efficient design is to JOIN the two tables and submit just one query. Then, as you process the results, you detect when the Department value changes and adjust your OUTPUT accordingly. Could it be the volume of data you are trying to present is just that much larger with your production data set than it was with your development dataset that it's taking that much longer to format the output? You provided so FEW details of the actual issue, it's VERY hard to be more helpful. Can you provide more details of what isn't working the way you want and why? Shawn Green Database Administrator Unimin Corporation - Spruce Pine
