Re: Question - table size
Re: Question - table size
- Subject: Re: Question - table size
- From: Chuck Hill <email@hidden>
- Date: Fri, 27 Feb 2004 11:14:38 -0800
- Organization: Global Village Consulting, Inc.
An entire row will always be read when faulting. 500 bytes? You're
worried about 500 measly bytes? :-) Put them together, a BLOB or a
CLOB can be worth factoring out, but ten 50 byte attributes? I'd not
think twice about that until I'd done a LOT of other optimizations.
Chuck
Kent Harris wrote:
I've got a table that is currently split into two tables because each
part is accessed at different times and for different reasons -- I was
thinking performance, why access the whole table when I only need one
part at any given time? Its a one-to-one relation between the tables
with propagate primary key. One of the tables is hit during batch
processing once a day whilst the other is hit occasionally during
web-driven activity.
However, it makes the user interface (maintenance by an operator) crummy
via a direct-to-java-client app. with a dynamic/rule-based generation of
the GUI. If I combine the two tables into one to improve the user
interface will the faulting mechanism help me out or will an entire
record always be read from the underlying database (mySQL)? Does it
really matter since the difference in record size is, oh say 1000 bytes
combined or 500 bytes each when separated.
Guidance by the experienced is always greatly appreciated.
- Kent
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives:
http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.
--
Chuck Hill email@hidden
Global Village Consulting Inc. http://www.global-village.net
It is a funny thing about life; if you refuse to accept
anything but the best, you very often get it."
-- W. Somerset Maugham
<shamelessPlug>
Practical WebObjects
http://www.amazon.com/exec/obidos/tg/detail/-/1590592964
</shamelessPlug>
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.