Thomas, 'd guess it is web application. How did you push data to app server ? Regards, rm. On 4/21/06, Thomas Day <tomday2@xxxxxxxxx> wrote: > > > You didn't say, or I didn't catch, whether this is a web based or a > client/server based application. In past jobs, where we had a client/server > based application the data was pushed to each client and cached on their > desktop when the table in question was this small. On web based > applications we pushed the data to the application server. > > Small snippets of data that are so heavily used should be stored as > variables in the application or cookies in the client's browser or > something. Theya re really part of the appllication, not the database. > -- Regards, Ranko Mosic Contract Senior Oracle DBA B. Eng, Oracle 10g, 9i Certified Database Professional Phone: 416-450-2785 email: mosicr@xxxxxxxxxx http://ca.geocities.com/mosicr@xxxxxxxxxx/ContractSeniorOracleDBARankoMosicMain.html