Hello, i'm writing a program for a uni project where several clients may interact with a database which resides on a server. To do this i am using RMI. I have been updating tables and submitting queries on the database ok. To do this i have simply been passing
string sql statements to the server and then returing an array/vector populated with the database results etc. However is this the best way to pass database data from a server to client?
Although this has been working ok, i'm wondering ahead if there may be performance issues with putting database rows in an array. For instance, what if the database returned 1000's of rows. Would the array be albe to take this and would the performance be acceptable?! Also, where a two dimensional array is not enough, on a single screen several arrays may be needed to populate the various views and data.
Any comments would be greatly appreciated, cheers