Article View: borland.public.interbase.opensource
Article #66Re: Which FreeWare/OpenSource Interbase is the best?
From: Jack Mason
Date: Tue, 05 Dec 2006 01:58
Date: Tue, 05 Dec 2006 01:58
30 lines
2982 bytes
2982 bytes
Sorry, I did not mean to start a debate. Our application is very small. We have retail book stores that will most likely never need more than 6 computers used as point-of-sale units. Connecting between stores is done over DSL for small, single-customer inquiries on a very limited basis. Scalability beyond this level is not significantly likely for these bookstore applications. Each computer is a single user from our standpoint, but may be as many as three concurrently running programs, each with multiple databases and multiple streams to the same table(s) open to the server. If we count only the open databases (we use Delphi), each user would have only about 6 connections open at any point in time. If we counted tables & queries, each user could have from 60 to 80 open at any given point. Coming from a Paradox background, we did not expand much in our capabilities when we went to IB, as straight a conversion as we could do. That is why we used IBO. We just needed a simple minded database system. IB was really overkill, but it came with Delphi and then Borland made the open source version available. Using the newer dual-core, hyper-threaded processor boards appears inevitable since we just buy computers off the shelf and we have been getting some of these when we purchase systems in the $400 range. If these are the same as SMP systems, then that needs to guide our direction also. This is only reason we are even looking at changing from IB 6.0.2.0 at this point. With three stores (more in the future), if it is only about $700 per store for IB, that is not a big deal unless we have to keep upgrading and paying again.
Technical Details
Message-ID:
<4574d21f@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news2.google.com!news4.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mailReferences:
<456abc46@newsgroups.borland.com> <456b4f58$1@newsgroups.borland.com> <456bbcc0$1@newsgroups.borland.com> <456bc83a$1@newsgroups.borland.com> <456d02d7$1@newsgroups.borland.com> <456d1ac6$1@newsgroups.borland.com> <456d33f0@newsgroups.borland.com> <456eeb5c$1@newsgroups.borland.com> <456eedd7$1@newsgroups.borland.com> <456f9253$1@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Thread: 106772,bfde2af1f896c514 X-Google-Attributes: gid106772,public X-Google-Language: ENGLISH,ASCII-7-bit Date: Mon, 04 Dec 2006 20:58:31 -0500 From: Jack Mason <jackmason@mindspring.com> User-Agent: Thunderbird 1.5.0.8 (Windows/20061025) MIME-Version: 1.0 Newsgroups: borland.public.interbase.opensource Subject: Re: Which FreeWare/OpenSource Interbase is the best? References: <456abc46@newsgroups.borland.com> <456b4f58$1@newsgroups.borland.com> <456bbcc0$1@newsgroups.borland.com> <456bc83a$1@newsgroups.borland.com> <456d02d7$1@newsgroups.borland.com> <456d1ac6$1@newsgroups.borland.com> <456d33f0@newsgroups.borland.com> <456eeb5c$1@newsgroups.borland.com> <456eedd7$1@newsgroups.borland.com> <456f9253$1@newsgroups.borland.com> In-Reply-To: <456f9253$1@newsgroups.borland.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit NNTP-Posting-Host: 66.156.66.25 Message-ID: <4574d21f@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1165283871 66.156.66.25 (4 Dec 2006 17:57:51 -0700) Lines: 30 Path: arc1-ca.pugleaf.net!g2news2.google.com!news4.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail