Re: Dynamically changing the number of columns included in a D2W query/listing
Re: Dynamically changing the number of columns included in a D2W query/listing
- Subject: Re: Dynamically changing the number of columns included in a D2W query/listing
- From: Ramsey Gurley <email@hidden>
- Date: Wed, 22 Dec 2010 09:44:37 -0500
On Dec 22, 2010, at 1:08 AM, Daniel Beatty wrote:
Greetings Gentlemen, Chuck, and Davids,
I am exploring how to limit the number of columns queried and used
in for a listing in D2W. My experiment uses ERModernLook, and has a
the SDSS DR1 data set. Several of the tables have an annoyingly
large number of columns (641 to be precise) and a large number of
rows (770k of them). If the JVM is tweaked to 3GB of memory,
ERModernLook can return a list from a blank query (taking nearly
2.5GB memory footprint). I have a few more tables with just about
as a bad of a scheme and size arrangement. It would be nice to use
this data set to measure just how much abuse D2W can handle.
It sounds like you're mainly interested in just thrashing the app to
see what it can do under stress. That database table sounds
sufficient for the job. Are you putting all 770K rows on a single
page? (^_^) I think it would be interesting to see it using a "real
world" setup with a batching display group also. That would probably
reduce the memory usage a lot, but that's still a ton of columns to
render.
A couple things would be handy for this experiment.
1. How do I use ERDQueryDataSourceDelegateInterface? It appears
that the interface requires implementation of the queryDataSource
and qualifierFromSender methods.
Just the queryDataSource method really. In the documentation I put on
the wiki, I included a qualifierFromSender() method since customizing
the qualifier on a query page seemed to be a common request.
2. Is there a way to specify different query data sources for
different tasks for the same entity (list versus inspect)?
I think the datasource is passed from the query page to the list
page. I may be mistaken, I'd have to look to be sure. Every inspect
page I've seen just uses the object(). No datasource involved.
3. How do I get more run time logging from the WO application
itself? I thought Shark could do something with the JVM. Can it
measure the memory foot print over time? If so, how?
I'm not sure, but I've heard Pascal mention he is using Nagios to
monitor memory usage.
Ramsey
Thank you,
Dan Beatty, M.S. CS (B.S. EECS)
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden