Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Database > SQL Language
|
SQL Language SQL Language discussions not specific to a particular RDBMS program or vendor.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Language section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old December 30th, 2005, 10:14 AM
Registered User
 
Join Date: Aug 2005
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default How to create a Database

Hi,

Can you please guide me How can I create a SQL database for 25 users?
What are the necessary things i will take care for performance?

Thanks


koushikroy
 
Old January 4th, 2006, 04:02 AM
Authorized User
 
Join Date: Dec 2005
Posts: 14
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Your question is not that clear. You may use any of the available open-source db servers like MySQL, PostGRESQL to create your database.
MySQL gives good performance. Or you may use commercial db servers like
SQL Server, Oracle etc. Or latest in the arena is post-relational db server called Intersystems Cache db server which is extremely fast.
You need to install the db server in your local machine or you need to hire space in hosting server. Then,create a db and then tables. You should assign privilege to users to work with your db.

http://www.ravishakya.com
 
Old January 4th, 2006, 04:03 AM
Authorized User
 
Join Date: Dec 2005
Posts: 14
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Your question is not that clear. You may use any of the available open-source db servers like MySQL, PostGRESQL to create your database.
MySQL gives good performance. Or you may use commercial db servers like
SQL Server, Oracle etc. Or latest in the arena is post-relational db server called Intersystems Cache db server which is extremely fast.
You need to install the db server in your local machine or you need to hire space in hosting server. Then,create a db and then tables. You should assign privilege to users to work with your db.
For performance, you may create indices on search keys, optimize tables.

http://www.ravishakya.com





Similar Threads
Thread Thread Starter Forum Replies Last Post
how do i create a new ado database ? jerryham VB.NET 8 October 13th, 2008 09:21 PM
Ex0201 - Create Database khempire C# 2 January 14th, 2008 08:26 PM
Unable to create database. rupen SQL Server 2005 4 December 6th, 2007 02:39 AM
Create database Yee MySQL 2 November 5th, 2004 06:14 AM
How to create a new database? gpc Classic ASP Databases 17 December 19th, 2003 10:24 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.