Donna- I may not be fully understanding the problem here, but if bandwidth is really the problem I don't really see the table structure as having much to do with it. It's really the data you are sending across the wire after it's rendered by CF that would take a long time (or not).
I suspect your time would be well spent working on minimizing the size of the HTML document and exploring ways to reduce the amount of data sent to the browser on each request. Assuming they have fast enough computers and the bandwidth is really the only problem... Things like caching data in the browser and handling sorting client side could be helpful. Maybe I am missing your point? -Cameron On Mon, Feb 22, 2010 at 2:09 PM, Donna Martin <[email protected]> wrote: > Good afternoon, > > Normally, I would not hesitate to create a self-join on an Oracle > table. However, in this instance, people from Africa are going to be using > the ColdFusion/Oracle site that I am creating on a very regular > basis. Their bandwidth is abominable. > > The plan is to sort documents based on document type and its association > with another documents. As an example, I will be listing a procedure (SOP), > and if record exists, all addenda, appendices, etc (DocumentTypes) -- hence, > the self-join. > > The table will not be huge-- between 2 - 3 thousand records. Is the > performance hit going to be great (Think 'very low' bandwidth here)? > > To make matters worse, there are also 3 types of training documents that can > be associated with the same primary document (the procedure in the above > example). At this point, I have opted to put these into another table with > an FK to avoid using more self-joins. > > Is this the best way to go? Let me know if you need more details. I'm at a > standstill until I get this resolved... > > Thanks much. > Donna > > PS It's been a long time since I have posted to this group...miss the > interaction! -- Cameron Childress Sumo Consulting Inc http://www.sumoc.com --- cell: 678.637.5072 aim: cameroncf email: [email protected] ------------------------------------------------------------- To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -------------------------------------------------------------
