Sorry, I forgot to mention my database: MySQL. Views aren't available until 5.x.
> -----Original Message----- > From: Ramesh Sabeti [mailto:[EMAIL PROTECTED] > Sent: Friday, December 12, 2003 6:43 PM > To: 'Apache Torque Users List'; [EMAIL PROTECTED] > Subject: RE: how best to "flatten" database > > > How about using a "view"? > > Ramesh. > > > -----Original Message----- > > From: Marc Dugger [mailto:[EMAIL PROTECTED] > > Sent: Friday, December 12, 2003 3:23 PM > > To: [EMAIL PROTECTED] > > Subject: how best to "flatten" database > > > > My database has 62 tables in it and the user wants to be able to > > dynamically > > select (via web app) individual data elements across tables for export > to > > a > > spreadsheet. The record count could be anywhere from 100 to upper > 1000's. > > Since I'm using Torque for persistence, I started using the OM to > traverse > > the data, but started fretting about the potential number of database > > hits. > > I've also considered straight SQL to do a broad select (JOIN > everything), > > but am not comfortable with dynamically constructing such a mammoth > > statement. Unfortunately, a database tool is not an option...it must > be > > from within the context of the application. Any gurus out there with > > advice/links to articles? Thanks in advance. > > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
