db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ramesh Sabeti" ...@reazon.com>
Subject RE: how best to "flatten" database
Date Sat, 13 Dec 2003 00:42:40 GMT
How about using a "view"? 

Ramesh.

> -----Original Message-----
> From: Marc Dugger [mailto:marc@socotech.com]
> Sent: Friday, December 12, 2003 3:23 PM
> To: torque-user@db.apache.org
> 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: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


Mime
View raw message