Jim Lawrence (AccessD)
accessd at shaw.ca
Thu Oct 9 19:18:04 CDT 2003
Gustav: Your comments are so timely. Today I went to lunch with a Database programming acquaintance and he was raving about this new database, Caché. He has worked extensively with Sybase right through to SQL2000 and Oracle from 5.1 to 9i and he is now working with this DB. He is totally impressed. He says that it runs about 50% faster for simple queries but when working with large Cubes experiences a steady 600 plus percent performance gain. He strongly recommended that I download the free evaluation copy, work my way through the tutorials and says they have been supplying excellent email support (free) when he has been running into problems. It was a very interesting lunch that extended almost a couple of hours. Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Gustav Brock Sent: Thursday, October 09, 2003 8:58 AM To: Access Developers discussion and problem solving Cc: accessdb2web at egroups.com Subject: Re: [AccessD] InterSystems Caché database engine Hi group Well, today I went to this hands-on seminar, and I'm impressed. The core of the engine is an object oriented data store. You create as easy as in Access - in a very nice designer using a basic like language - classes for storing data. When compiled, these classes are at once compiled too - and represented - as tables via ODBC and JDBC, classes via C++, Java, ActiveX (COM), .net and XML, and you can access the data simultaneous via all interfaces. These layers are all highly efficient they claim is the main reason for the high speed of the engine next to the speed of the engine itself. Further, you can create CSP pages similar to ASP and JSP pages with a direct connection to the engine. An add-in for Dreamweaver is offered with wizards for creating web pages. These pages are interesting as they offer live update of presented data via either a server call or a hidden frame meaning that requery or repaint of the displayed page is avoided - this is in my opinion mandatory for anything serious application-like running in a browser. The best perspective of this, in my eyes, is that you can start using the engine and your proven tools whatever they might be (Access) while moving to or adding other interfaces like another language, a browser interface, XML or web services (SOAP). Rome was not built in one day, remember. The engine scales to shadowed servers, clusters and TB size with no more efforts than within reach of a developer (we are impatient and really have no time for this, you know), and it runs on close to anything including WinNT/200x/XP, Redhat/Suse Linux, Solaris, OpenVMS, Tru64, HP-UX, AIX, and Win ME/98 - even Win95 - and MacOX with the next release - requiring modest hardware only. /gustav >> Just noticed this option for a free developer license: >> http://www.intersystems.com/downloads/index.html >> Anyone having experience with this engine as a backend for Access or >> otherwise? >> The free license doesn't allow you to sell your apps. It is, however, >> not time limited. _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com