Go Premium for a chance to win a PS4. Enter to Win


what hardware needed to store huge databases?

Posted on 2001-08-06
Medium Priority
Last Modified: 2010-04-06
hello Sirs

I would like to ask about the hardware needed {Servers and their featurs......other H\W} for a filling System developed for a company that consist of 18 department which all have files that want to store, retrive,and Search from the database .
The system is written by delphi programming language and the tables are created using paradox ,the application is CGI (Common Gateway Interface).
The idea is that :to let those who are responsible from files in their department open the application through the net of the company.
 _The number of files are unlimited and increase continously
 _Most of the company files are writtem in MSword.

thanks in advance
Sahar Elsadig Elamin
Question by:Sahar
LVL 17

Accepted Solution

inthe earned 160 total points
ID: 6357412
just to mention msword files are quite big so you will need to work out an average size of the documents and approx how many documents are going to be made over say a year and * that together to see the bare minimum size harddisk you will need.
youll probably want to at least double the result then add the size of the operating system and software needed to run the db including your delphi app.
with harddisk sizes these days it shouldnt be a problem to stick at least a couple of 40-50g disks in a server..

Assisted Solution

heathprovost earned 160 total points
ID: 6357725
Just my humble opinion, but I dont think paradox is at all suited for such a demanding task.  If I understand correctly you are wanting to store ALOT of BIG files in BLOB fields inside of a database correct?  Paradox in my experience suffers for index corruption problems in even small litely used multiuser applications, and it is a pain to keep reparing things. And it is sssslllloooowwwwwww.  I would highly recommend going with a full blown DBMS such as Interbase, Oracle, or MSSQL to do this kind of heavy lifting.  As for hardware, I would say that would end up depending on the chosen DB.  Paradox can really only scale to a certain point both in maximum table size and memory use, so throwing big iron at it wont help a whole lot.  On the other hand the big DBMS's such as I mentioned LOVE having gobs and gobs of memory and big, fast hard drives...  If I were specking a system for this I would probably choose the following:

At least a 900Mhz processor, preferable 2 (if not on paradox, paradox wont get much benefit from a dually) Of course the faster the better...

Either an IDE Raid controller or a SCSI Raid controller - IDE is much, much cheaper, but is also a tad bit slower for this kind of stuff and the SCSI stuff is usually hot swapable so that is a plus.

Lots of memory, at least 512MB, preferable 1 Gig or more. With memory as cheap as it is now you might as well max the motherboard out... Again, if you stick with paradox I doubt any more than 512MB will do you any good.

at least 2 80 gig drives.  If you get 2 than set up a mirror using the raid controller.  If you go the scsi route it is much more cost effective to get 5 40gig drives and setup a RAID5 array.  Then replacement costs are not as high when you have a failure.

I would also recommend get 2 NIC cards that do load balancing so you can boost your network throughput as much as possible.  This is a pretty cheap way to get better network performance.

A system like this can be had for about 2k to 3k US dollars depending upon options chosen

Of course the above is strictly for the database server.  I would highly recommend putting the web server on a seperate box to maximize performance.  Running the web server on the same box as the DB isnt a good idea if the web site gets alot of use.  The two services will tend to fight with each other for memory bandwidth and cpu time.  The web server doesnt need to be much, just enough to handle the expected load, the DBMS will be doing most of the work if you code everything properly.  Of course if you are not expecting high utilization then putting them both on one box is an option.

LVL 15

Assisted Solution

simonet earned 160 total points
ID: 6357902
First of all, forget about Paradox. Paradox is simply for you to GET STARTED in LEARNING doing some DB programming. It's not at all suited for a full-blown professional application.

If you're gonna stick with Paradox, than ANYTING will do, as long as you have a HD large and fast enough to hold all the files you want and has a fast network.

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!


Assisted Solution

FrodoBeggins earned 160 total points
ID: 6358735
Yes, I agree PARADOX can't get the load. The same for using os like Windows 98. Just not done for server.

I suggest you the folowing:

Oracle or SQL Server (I prefer Oracle. it's more secure). IBM DB2 can make it too, but it costs more and it is slower than Oracle. SQL Server is esaier for administraton, Oracle is well-known world leader.

Use SCSI RAID controler. It may be more expensive, but my test server got 6 to 10 times (!) faster after is changed the configuration from (2 SCSI 80 IBM disks) to (4 SCSI 160 RAID 1+0 IBM discs) with no other config change.

OS: Windows NT or 2K - they all can handle te load. Use the latest servicepack. Linux can do it too.


Assisted Solution

VSF earned 160 total points
ID: 6359047
Why not using INTERBASE it's free and can handle the task!

How many computers are attached to the network!?

<edited by PashaMod>
LVL 26

Expert Comment

by:Russell Libby
ID: 8741460
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:

Split points between inthe, heathprovost, simonet, FrodoBeggins, and VSF

Please leave any comments here within the next seven days.
Thank you,

EE Cleanup Volunteer

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The uses clause is one of those things that just tends to grow and grow. Most of the time this is in the main form, as it's from this form that all others are called. If you have a big application (including many forms), the uses clause in the in…
In this tutorial I will show you how to use the Windows Speech API in Delphi. I will only cover basic functions such as text to speech and controlling the speed of the speech. SAPI Installation First you need to install the SAPI type library, th…
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…
Screencast - Getting to Know the Pipeline

926 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question