🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.interbase.opensource
Article #66

Re: Which FreeWare/OpenSource Interbase is the best?

#66
From: Jack Mason
Date: Tue, 05 Dec 2006 01:58
30 lines
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-mail
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>

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