I.T. Discussion Community!
-Collapse +Expand
DBA
Search DBA Group:

Advanced
-Collapse +Expand DBA Store
PRESTWOODSTORE

Prestwood eMagazine

April Edition
Subscribe now! It's Free!
Enter your email:

   ► MB LobbyDBA, Databases, & Data BoardInterbase Topic   Print This     

Is InterBase The Best Choice ?

Is InterBase The Best Choice ? in Interbase topic (part of our DBA, Databases, & Data group).

Quick Search: InterBase   Is InterBase   Is InterBase Best   Choice   
essystem
Brazil
I develop system for stores still in CLipper 5.3 I will change to Delphi. Is the InterBase the best choice for use in customers that will not pay for traditional products as SQLServer and others ? Is IB faster enough to run in PIII 800Mhz 128 MB RAM as server for 2 to 10 machines in a LAN ? And does it keep fast even when grow about to 200,000 to 300,000 register in two or three tables ? My system handle 20 to 2000 register in terms of sells and 50 to 5000 registers in terms of selled products a day. If IB is not the best choice what should i use ?
Thank You !
 Posted 18 years ago (Thread Starter)
Comment Quote
About essystem -Collapse +Expand
Visit Profile
Membership pending.
Member subscribes to this thread but email is NOT VERIFIED.
Email Not Verified!
Once email is verified, we will review and approve the account.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #4560, 2 reply
Thread Started 12/11/2001 2:33:00 PM
View Counter=2624
Last Reply Posted 1/4/2018 1:49:48 AM)
Location=Brazil  
Joined=18 years ago   MB Posts=1  
Scott Wehrly
Prestwood IT
 (Inactive)
Las Vegas, NV USA
This depends on what you mean by "will not pay for traditional products". Even with InterBase, if you're going to run a server installation, you must purchase the server license ($50 U.S. for media, $200 U.S. for the license) before you can install the server. And then, you have a per-user license for each additional user beyond the one license that comes with the server (it averages out to $120 U.S. per additional user).

This approaches the cost of a SQL Server license for server and concurrent users, so your customers are going to have to face up to the license costs one way or another.

There are other pricing options - for instance the Firebird version of InterBase (
Old UBB Archived Link: [URL=http://www.ibphoenix.com]ibphoenix.com[/URL]
), or even the DB server from Advantage Database (
Old UBB Archived Link: [URL=http://www.advantagedatabase.com]AdvantageDatabase.com[/URL]
). Both products provide the performance you desire, but since they are lesser known, they are a tougher sell to your customers.

As for speed and performance, InterBase 6.5 will easily meet the transactional needs you indicated. I have seen equivalent performance on medium scale databases (approaching 4GB of data) between InterBase and SQL Server. Naturally, the more resources available on the server, the better performance you will see in InterBase.
 Posted 18 years ago
Comment Quote
About Scott Wehrly -Collapse +Expand
Visit Profile
Inactive member.
Member does not subscribe to this thread.
Old Account!
If this is your account, sign in to activate web presence data (sign in quarterly to keep active). Alternatively, you can subscribe to our monthly eMag with a valid email address.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #4565 (Level 1.1)  Reply to 4560
Thread Started 12/12/2001 6:55:00 AM
View Counter=2
Location=Las Vegas, NV USA 
Joined=17 years ago   MB Posts=442   KB Posts=19  
Most Recent Post
PS_661
-- --

Advanced filters for check outcomes. Game Guardian APK Download App – latest Version of 2017 [No Root] If you want to learn how to make your own trainers and scripts for Android games.

 Posted 15 months ago
Comment Quote
About PS_661 -Collapse +Expand
Visit Profile
Membership pending.
Member subscribes to this thread with a verified email.
Member pending approval.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #16958 (Level 2) and Parent is 4560
Reply Posted 1/4/2018 1:49:27 AM
Location=-- -- 
Joined=15 months ago   MB Posts=3  

Revive Thread!

Add a comment to revive this old thread and make this archived thread more useful.

Write a Comment...
Full Editor
...
Sign in...

If you are a member, Sign In. Or, you can Create a Free account now.


Anonymous Post (text-only, no HTML):

Enter your name and security key.

Your Name:
Security key = P1222A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #4560 Counter
2624
Since 4/2/2008
-
   Contact Us!
 
PrestwoodBoards.com was developed and is maintainted by me. Do you have a question or suggestion? Do you see a problem? Contact me now. My goal is to build an ad-free and spam-free source of I.T. information with many contributers (ok to promote your website/company in your bio). Yes, my company Prestwood IT Solutions is mentioned in my bio which shows with every post, but you can contribute and promote your pet project too!

768 People Online Now!!  
Sign In to see who's online now!  Not a member? Join now. It's free!
Show more stats...


©1995-2019 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech