Local database Performance

Please do not use to report errors- use your regional help desk.
Please mark posts as being for RPG or RDMLX (LANSA) developer.
To subscribe by email, display this forum, scroll to the end and select ‘Subscribe Forum’.
Post Reply
soapagent
Posts: 93
Joined: Mon Jul 16, 2012 6:19 pm

Local database Performance

Post by soapagent »

I'm interested in using locally stored tables in online forms. If I load up some tables locally on first access (perhaps on sign on) and then load these tables into my views rather than from the iSeries database can I expect a performance improvement?
Mark_Dale
Posts: 61
Joined: Thu Apr 19, 2012 11:06 am

Re: Local database Performance

Post by Mark_Dale »

I think the main performance benefit comes if you have enough information on the client to avoid some trips to the server. If the user was continually downloading a lot of data, I guess it would help performance if that data was available on the client.
Post Reply