Re: Lookup/Code table as hot block

Thomas, 'd guess it is web application.
How did you push data to app server ?

Regards, rm.

On 4/21/06, Thomas Day <tomday2_at_gmail.com> 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_at_rogers.com
http://ca.geocities.com/mosicr@rogers.com/ContractSeniorOracleDBARankoMosicMain.html

--
http://www.freelists.org/webpage/oracle-l