ODMG vs. PB

2003-04-03 Thread Jacob Hookom
Looking at the performance benchmarks at OJB's page, there's a dramatic difference in speed between ODMG and PB implementations. Is this because of the object locking features with ODMG, or is it because ODMG uses PB and that extra adapter layer causes slow downs? -Jacob ---

RE: select column criteria

2003-04-02 Thread Jacob Hookom
Another thing that can be done with OJB is to create multiple Object mappings to the same row. For example, I store web page content in a database and like you said, it would be slow to pull down all that clob content. PageHeader[6 cols pk, header fields] PageContent[2 cols pk, clob fields] Page

RE: Default Cache - bug? design catostrophe? user error?

2003-04-01 Thread Jacob Hookom
There are multiple Cache options that offer different scopes for transactions, along with PersistenceBrokers. You should look at the API for options on concurrency and transaction isolation with changing the previously stated items in the OJB.properties. -Jacob | -Original Message- | Fro

RE: Webapp google queries: What is a good way to present multiple web pages with query results ?

2003-03-28 Thread Jacob Hookom
I followed Scott's example and put one together for MySql, with setting up start index, end index with limit: public final class MySqlGenerator extends SqlGeneratorDefaultImpl { /** * @param arg0 */ public MySqlGenerator(Platform arg0) { su

RE: PersistenceBroker State Question

2003-03-28 Thread Jacob Hookom
(). | | -Original Message- | From: Jacob Hookom [mailto:[EMAIL PROTECTED] | Sent: Friday, March 28, 2003 11:29 AM | To: [EMAIL PROTECTED] | Subject: PersistenceBroker State Question | | | Pertaining to caching and speed of the PersistenceBroker, am I on the | right | track for structuring calls like so

PersistenceBroker State Question

2003-03-28 Thread Jacob Hookom
{ broker.close(); } } Does the cache in general get flushed when I call broker.close()? I'm just using the Broker in Single-VM mode. Regards, Jacob Hookom Student, University of Wisconsin - To unsubscribe, e-mail: [

[GURU HELP NEEDED] Distinct on Field

2003-03-27 Thread Jacob Hookom
The goal is to select children based on a distinct parent id. Example of the sql code: SELECT f.ForumTitle, (SELECT Max(p.PostDateTime) FROM tbl_Posts p WHERE p.Forum_ID = f.Forum_ID) as MaxPostDateTime FROM tbl_Forum f ORDER BY MaxPostDateTime DESC I would like to be able to accomp

[OT] Torque Pre-Populate DB with project-data.xml/.dtd

2003-03-26 Thread Jacob Hookom
ema.xml is: Artikel The tag specified in ojbtest-data.xml is: Article Where is the lynch pin? ________ Jacob Hookom "The first rule of intelligent tinkering is to save all the parts" - To unsubsc

How to Min/Max

2003-03-24 Thread Jacob Hookom
Hey all, the mail archives are not working properly atm, so I'm sorry for the post, but I'm wondering how to handle grabbing the min/max in a query without doing a comparator on the returned List? Many Thanks! ________ Jacob Hookom "The first rule