Whts faster n better - MsAccess or Mysql

**dreamselite** · 10-19-2004, 11:12 AM

Hello,
Well i'm preparing to launch my new site. Since i want to start with little investments i plan to go for linux hosting with mysql support and 10mb space.

But before i start i just want to know whether 10 mb space will be enough during the first 2 to 3 months. Since i wont be using graphics in this site my concern is only abt the database. Suppose there is a directory containing a list of sites based on catagories and there are a record of 1000 websites in it with their url, title, discription, etc. wht would be its file size.
Please reply to me fast coz i'm already behind my schedule.

Harish
Dreams Online- Web Services

**admin** · 10-19-2004, 12:05 PM

10 MB Web space will be enough for a directory with 1000 Links.

I would use Linux server with PHP and MySQL.

**flyflash** · 10-20-2004, 12:57 AM

mysql or mssql?

**shablon** · 10-29-2004, 04:23 PM

mySQL is software for Web Servers
MS Access for local computers...
But i think PostgreSQL better that all

**admin** · 10-29-2004, 06:26 PM

I vote for MySQL. Its good for web as it support SQL Query.

MS Access it have a 10 user at a time limit, but is ok for small web sites. Good for those who use ASP.

I use PHP and MySQL for designing web sites.

**jthrasher** · 10-30-2004, 03:03 AM

MsAccess Rules and so much easier to manage.

**Arc** · 10-30-2004, 08:36 AM

i use mysql

**Nemezis** · 11-01-2004, 09:28 AM

MySQL is the BEST! for Web it is an ideal variant.
What about MsAccess.. I dont like it..

**dominion** · 11-11-2004, 06:36 AM

Originally Posted by shablon

mySQL is software for Web Servers
MS Access for local computers...
But i think PostgreSQL better that all

MySQL is probally the fastest because of the 'extentions' or whatever you want to call them. Check out InnoBB (or something like that). I'm not too expirenced with other mysql stuff, nor other databases, but mysql is the easiest to learn because more people talk and have tutorials for them (like me).
PostgreSQL seems really nice... but I'm never tried it. I believe you can change the type of SQL by changing the funtion command. Such as mysql_query() should be something like prsql_query() or whatever the 5 abriviated letters are for that database. You have to be careful that you don't use a feature that may not be supported in other SQLs...what do I know...don't listen to me anymore...I have nothing more to say...stop reading this...please...I'm tired of typing...so will you stop reading this...thank you.