From their FAQ: Is the ANTs Data Server an accelerator for other database systems? While the ANTs Data Server is designed to be a standalone database, it can also be used to complement conventional database systems by moving high contention, "hot spot" tables to the ANTs Data Server. This can be achieved with minimal application changes since the ANTs Data Server supports SQL programming through industry-standard ODBC and JDBC APIs. [1] I am beginning to dream of ODBC-based kinda database links between ANTS and Oracle ... Great for boosting performance. Abuse? Which abuse? Regards, Stephane Faroult RoughSea Ltd http://www.roughsea.com On Wed, 1 Sep 2004 08:58 , 'Cary Millsap' <cary.millsap@xxxxxxxxxx> sent: I just don't get the whole "cache everything, and everything will be ok" argument. The vast majority of the slow tasks I've seen in the past ten years have all executed "in cache" to begin with! ...And fixing them has, almost every time, required either optimization = of SQL, or optimization of the application code that calls the SQL. I just don't see how /any/ database can defend itself against all the types of abuse that an application developer can throw at it. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com[2] * Nullius in verba * Upcoming events: - Performance Diagnosis 101: 9/14 San Francisco, 10/5 Charlotte, 10/26 Toronto - SQL Optimization 101: 9/20 Hartford, 10/18 New Orleans - Hotsos Symposium 2005: March 6-10 Dallas - Visit www.hotsos.com[3] for schedule details... -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx[4] = [oracle-l-bounce@xxxxxxxxxxxxx[5]','','','')">oracle-l -bounce@xxxxxxxxxxxxx[6][] On Behalf Of Peter Robson Sent: Wednesday, September 01, 2004 8:14 AM To: Jonathan Gennick Cc: oracle-l@xxxxxxxxxxxxx[7] Subject: Re: ANTs Data Server? Jonathan, Wednesday, September 1, 2004, 2:03:04 PM, you wrote: JG> Has anyone ever heard of these guys? JG> http://www.antssoftware.com/index.htm[8] No, I have not heard of them. The web site refers to in-memory products, and Cache immediately springs to mind. If you have ever looked at that product, and can remember Adabas, there are remarkable similarities. The key question to ask of these vendors is what data model their product supports. The answers can be interesting... peter edinburgh ............. --=20 pgro@xxxxxxxxx[9]','','','')">pgro@xxxxxxxxx[10][10] --- Links --- 1 http://www.bijonline.com/Article.asp?ArticleID=948&DepartmentID=6 2 modules/refer.pl?redirect=http%3A%2F%2Fwww.hotsos.com 3 modules/refer.pl?redirect=http://www.hotsos.com 4 javascript:parent.opencompose('oracle-l-bounce@xxxxxxxxxxxxx','','','') 5 javascript:parent.opencompose('<a href= 6 javascript:parent.opencompose('oracle-l-bounce@xxxxxxxxxxxxx','','','') 7 javascript:parent.opencompose('oracle-l@xxxxxxxxxxxxx','','','') 8 modules/refer.pl?redirect=http%3A%2F%2Fwww.antssoftware.com%2Findex.htm 9 javascript:parent.opencompose('<a href= 10 javascript:parent.opencompose('pgro@xxxxxxxxx','','','') ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------