Comments on: More bitching about MSSQL

By: yarex

yarex — Fri, 27 Oct 2006 16:54:26 +0000

Nicholas, that is not absolutely true, if you do not change default settings, then i think first 8k bytes are stored on the same page and only the remaining bit is on own pages that you have then to access using special “binary” way.

Up to 8k chars you can select directly with select statement.

By: Anton Clarke

Anton Clarke — Tue, 03 Jan 2006 23:23:12 +0000

It’s interesting that you should point out how people do inappropriate comparisons between products to make a point. However, it is usually Linux people comparing their latest build to MS Windows Server 2003 and quoting problems that existed back in Windows 3.1! Linux (not BSD people I might add) seem to need to MS bash – a little reciprocation is not unexpected.

Back to the point, you may want to store more than 8k for ‘personal’ information, but it is unlikely.

I did some test vectors on SQL Server to 2005 to MySQL 5.0 and found ‘My’ to be lagging in speed a little still – though I needed 100,000 rows before this became apparent.

‘My’ is great for read-only applications, or where updates are minimal (user forum posts etc) but on huge dynamic databases (city financial) I would still go a more commercial route. (Oracle etc)

Let the flaming commence.

By: Nicholas

Nicholas — Mon, 14 Nov 2005 16:50:54 +0000

You do know that TEXT and BLOB data types aren’t counted towards your row size in MSSQL, right?

If you’re making database rows with more than 8k of data, you should probably re-evaluate your database structure.