|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Stop making mediocre tutorials.The best tutorials are video! Camtasia Studio makes it easy to create engaging, buzz-building screen videos at any size, in any popular format. Download the free trial!
|
|
#1
May 20th, 2003, 04:46 PM
|
|||
|
|||
|
mySQL vs MS SQL
I have a database of postal codes in a mySQL database that takes about 50 MB up of space and have the identical database in MS SQL server that takes up 250 MB of space. Why is this? Is there any way to reduce the space MS SQL server uses? (yes I am forced to use it)
|
|
#2
May 20th, 2003, 11:00 PM
|
|||
|
|||
|
I would suspect the reasons are among these:
1. Different data definitions -- are you sure that every single column is defined with the most efficient datatype and parameter in MSSQL? Are you using VARCHAR(255) where VARCHAR(12) would be enough, for example? 2. Integrity -- believe it or not, MS SQL has many more data integrity and redundancy features than MySQL. Of course, extra integrity features often mean more data usage. 3. Every database has different implementations for actual physical storage, so it stands to reason the same data in different databases would use different physical space. None of this means the MS SQL is intrinsically bad, although I much prefer other SQL systems, such as PostgreSQL or Oracle (and not MySQL).
__________________
The real n-tier system: FreeBSD -> PostgreSQL -> [any_language] -> Apache -> Mozilla/XUL Amazon wishlist -- rycamor (at) gmail.com
|
|
#3
May 21st, 2003, 04:16 AM
|
||||
|
||||
|
Maybe you decided that your datafile size has to be 250 Mb .... open enterprise manager and check.
To have a data integrity level comparable to MSSQL you should be using InnoDB tablehandler in MySQL.
__________________
My blog about OpenSource Databases PDF tutorials about OSS databases, DBMonster ... Please contribute to Open Source Development, fill bug reports!!! Developer Shed eSupport Commented my.ini/my.cnf (PLEASE ADD YOUR OWN CONFIG TRICK) Understanding SQL Joins An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries
|
|
| Viewing: Dev Shed Forums > Databases > Database Management > mySQL vs MS SQL |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
