• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Question - table size
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Question - table size


  • Subject: Re: Question - table size
  • From: "Jerry W. Walker" <email@hidden>
  • Date: Fri, 27 Feb 2004 15:18:06 -0500

You will always fault in an entire record.

I think, if you timed it, you'd find that the round trip to the DB absolutely dwarfs the reading of the extra 500 bytes. I'm not sure, frankly, that your timing resolution would be sufficient to measure the difference presuming that you're using enterprise level hardware and a reasonable channel between DB server and app server (if they happen to be separated).

Jerry

On Feb 27, 2004, at 12:50 PM, 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

--
__ Jerry W. Walker
c o d e f a b - "High Performance Industrial Strength Internet Enabled Systems"
email@hidden
212 465 8484 X-102 office
212 465 9178 fax
_______________________________________________
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.



References: 
 >Question - table size (From: Kent Harris <email@hidden>)

  • Prev by Date: Re: Is WebObjects Dead?
  • Next by Date: JDBC Model - to - JNDI Model Relationship Question
  • Previous by thread: Re: Question - table size
  • Next by thread: JDBC Model - to - JNDI Model Relationship Question
  • Index(es):
    • Date
    • Thread