There's been much discussion about the object-relational (OR)
vendors on this list.
Some have said that these products not only add purchase and
ownership costs and support costs, don't really reduce the
complexity of the system, nor increase performance (contrary
to their claims). Actual users who have benchmarked should
offer hard data.
I concure with these arguments and add that using the caching
built into Oracle 8i (cache fusion) and better yet the up coming
9i read and write cache fusion across a cluster of db boxes
is the highest performance way to go. Forget OR, even forget
CMP. It's a pipe dream of the EJB spec writers that not having
to know your data and how to optimally access it (writing good
sql) is some how possible. Remember these ideas where brought
to you from the same bunch that think forced serialized calls
into a bean is from a whole system design perspective a good
idea. :))
Use or configure your DB to be more efficient at caching;
Oracle 8i cache fusion.
curt
> -----Original Message-----
> From: Indy DeLeon [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, January 10, 2001 10:52 PM
> To: [EMAIL PROTECTED]
> Subject: Caching anyone
>
>
> I am looking for a database caching software that works with
> EJB (either CMP
> or BMP).
> The system needs to support caching SQL result sets for
> 1. Simple SQL
> 2. Complex SQL involving multiple table joins
> 3. Stored Procedure possibly returning multiple result set (a
> feature of
> Sybase Server)
> 4. A mechanism to update the cache
> 5. Cache Mangement (LRU algorithm, Cache faulting,...)
> 6. Paging support (If Stored procedure returns a 100000 rows,
> the API should
> allow client to get a subset of the data as soon as it is
> available (say as
> soon as first 50 rows are processed). The client should be
> able to ask for
> next page (next 50) which should come from the cache.
>
> I looked at TopLink, but it does not support caching for
> Stored Procedure
> since it returns one or more objects. Only object level
> caching is supported
> (someone please correct me if I am wrong).
> I also looked at TimesTen's Front-Tier, but the software main
> strength is
> the ability to do complex queries on cached data. They do not
> support Stored
> Procedure, Paging and so on (again, please correct me if I am wrong)
>
> Suggestion anyone!!!!!
>
> Thanks in advance....
>
> Indy
>
>
>
>
>
> _______________________________________________________
> Send a cool gift with your E-Card
> http://www.bluemountain.com/giftcenter/
>
> ==============================================================
> =============
> To unsubscribe, send email to [EMAIL PROTECTED] and
> include in the body
> of the message "signoff EJB-INTEREST". For general help,
> send email to
> [EMAIL PROTECTED] and include in the body of the message "help".
>
===========================================================================
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff EJB-INTEREST". For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".
