Hi Guys,
I have an swing application that uses JDO as it's persistence layer. The application has a centralized server and the clients run at remote locations over a 512mbs ADSL line. As you have probabley guessed we are experiencing performance related problems which relate to data retrieval and the number of sql statements that are being executed.
One solution I am considering is to use the value object
pattern to access the data, and to remove all database access from the client. Is this a good idea? I have done some tests and the performance increase is huge, but I just want to know what other peoples opinions are on using this method. I know this method has other advantages as well, beyond the performance gain, so it is quite attractive.
The other solution (which is going to happen anyway, as our JDO vendor no longer supports the product) is to move from JDO to Hibernate, but I am not sure that this alone will solve all of the performance problems. Again, anyone have experience in this field.
Any help would be greatly appreciated as I would hate to go down the wrong track only to find I have made the wrong decision!
Regards,
Brian