Xref: alice comp.databases.oracle.server:47246 Path: alice!news-feed.fnsi.net!netnews.com!newspeer1.nac.net!news.maxwell.syr.edu!nntp2.dejanews.com!nnrp1.dejanews.com!not-for-mail From: pbor8198@my-dejanews.com Newsgroups: comp.databases.oracle.server Subject: Re: Best aproach for multiplatform RDBMS development Date: Mon, 26 Apr 1999 15:26:22 GMT Organization: Deja News - The Leader in Internet Discussion Lines: 65 Message-ID: <7g20ip$hba$1@nnrp1.dejanews.com> References: <19990415074046.20809.00000092@ngol08.news.cs.com> <7fg4du$vvv$1@nnrp1.dejanews.com> X-Article-Creation-Date: Mon Apr 26 15:26:22 1999 GMT X-Http-User-Agent: Mozilla/4.5 [en] (WinNT; I) X-Http-Proxy: 1.0 x6.dejanews.com:80 (Squid/1.1.22) for client 195.109.110.33 Hi, I'm working on a project that needs a object mapping tool. For this we use Rogue Wave's dbtools and RW-Metro. Perhaps it has some nice features for you also, go check it out. http://www.roguewave.com/products/ Paul. In article <7fg4du$vvv$1@nnrp1.dejanews.com>, bmaccion@greenacres.com wrote: > One transaction a second is rather funny. I'm working with a system that is > running about 250,000,000 sql transactions/day (you do the math). Granted > this isn't SQL7 or Access and we're also about 70% idle (ummm, smp > hardware). Oh yea, it's on ~20G of data so it's a fair amount of data (not a > warehouse mind you) > > The catch here is that _my_ realtime isn't necessary _your_ realtime. We > don't use any stored procedures but that's just the way I like it. I hate > triggers and stored procedures but that's because I'm old and still think > that the database should just store and fetch data. > > Our systems have a code layer between the application code and the database, > this allows us to handle different databases at the code level and not with > stored procedures. > > bobm > > btw: Teradata doesn't have _real_ stored procedures yet so be careful what > database features you use if you want to be portable. (although the ESQL_C > from teradata really really stinks too). > > In article <19990415074046.20809.00000092@ngol08.news.cs.com>, > jplahman@cs.comnospam (Jplahman) wrote: > > In article > > , > Todd > > Graham Lewis writes: > > > > >"real time performance"? Really? > > > > Please define real time. The reason I ask is we receive data (1200 integer > > variables) from a plant control system at 55msec (or 18 samples /sec). We are > > just now looking at converting our legacy application to a database like > Oracle > > because we were always told that a database engine cannot keep up with this > > high rate of data. The fastest it can handle data is one transaction / sec. > > > > JPL > > > > jplahman@cs.com > > > > -----------== Posted via Deja News, The Discussion Network ==---------- > http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own > -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own