Anyone know of a good/quick (and free) way to compress HTML code?

[Martin Harran]

[...]

How much "more free" can you get than no charge?

SQL Server, even Express Edition is much more expensive than MySQL or
PostGres SQL. For starters, you have to spend a couple of hundred $$ for a
MS OS - a lot more if you're going to use it as a server. Windows XP Home
Edition won't hack it.

OP said he was using Access which means he's already on Windows.

Linux, OTOH, is completely free. As are both MySQL and PostGres SQL (as
long as you're not going to include them in a commercial application).

SQL Server Express can be used in commercial apps.

 

[Andy Dingley]

And both outperform SQL Server on equivalent hardware.

That's a very dubious benchmark. Even MUMPS wil outperform SQL Server
for some apps on some hardware. It's not because it's "better" though,
it's because it's pitched at a smaller-scale market sector. MySQL
(less so for Postgres) is a hierarchical DB with some pretensions to a
relational facade. If you ask it to do hierarchical stuff, which is
all most small-scalle DBAs ever understand or use, then it runs
quickly and efficiently. If you ask it to model some valid relational
structure that doesn't map onto a hierarchical model well, then it
falls flat.

So MySQL will work fine for nearly all small web sites, whatever
they're doing, and is probably what ought to be used for them. However
saying that it will always beat SQL Server is too misleading to be
worth stating.

 

[Andy Dingley]

Exactly what "valid relational structures" are you talking about? Both
do relational designs quite well.

As the quickest way to a non-esoteric benchmark that illustrates SQL
Server stomping MySQL on selects rather than on updates (where MySQL
is piss-poor on anything involving more than one table anyway) then
look at something involving numerous tables and numerous foreign keys.
If the foreign key is between the primary keys, then they're
comparable. If it isn't, then MySQL suffers.

As to SQL Server vs. DB2, then my headache du jour is three-way
porting between Oracle, SQL Server and DB2. The idea that "DB2 simply
owns all the big iron space" just hasn't been true for years. Even
though our particular app does admittedly have crude and hierarchical
legacyy ideas about how to model a database.

 

[Jerry Stuckle]

[...]

How much "more free" can you get than no charge?

SQL Server, even Express Edition is much more expensive than MySQL or
PostGres SQL. For starters, you have to spend a couple of hundred $$ for a
MS OS - a lot more if you're going to use it as a server. Windows XP Home
Edition won't hack it.

OP said he was using Access which means he's already on Windows.

Linux, OTOH, is completely free. As are both MySQL and PostGres SQL (as
long as you're not going to include them in a commercial application).

SQL Server Express can be used in commercial apps.

Yes, but he'll probably have to upgrade his Windows to run SQL Server.

And if he goes with either MySQL or PostGres SQL, he can dump Windows
and go with a good OS (Linux).

And I should clarify - both MySQL and PostGres SQL can be used in
commercial applications at no charge. But if you distribute them (at
least MySQL - haven't checked PostGres recently) there is a charge.

And both outperform SQL Server on equivalent hardware. Let's see you
run Windows 2003 Server, SQL Server (even Express Edition), IIS, SMTP
server and the rest on 128M. Heck - you can't even boot W2K3 Server
Server in 128M.

But Linux and all the rest run quite well in that. And bring the system
up to 512M-2K and it screams.

Sorry - Windows is an OK desktop. But it makes a lousy server.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
(e-mail address removed)
==================

 

[DAVID]

I thought the limit for a memo field was nearer 65K?

No, the limit for a Textbox CONTROL is 64K OR 32K. The limit
for a memo FIELD is 1GB or 2GB.

(david)

 

[Brian Cryer]

No, the limit for a Textbox CONTROL is 64K OR 32K. The limit
for a memo FIELD is 1GB or 2GB.

So if you are using straight Access (no DAO etc) then you are in effect
limited to a textbox which would explain where the 64K limit comes from.
Hence the limit on a memo field unless you use DAO etc which bypasses using
a textbox.

Nice to understand where the limitations come from. Thanks.

 

[Jerry Stuckle]

That's a very dubious benchmark. Even MUMPS wil outperform SQL Server
for some apps on some hardware. It's not because it's "better" though,
it's because it's pitched at a smaller-scale market sector. MySQL
(less so for Postgres) is a hierarchical DB with some pretensions to a
relational facade. If you ask it to do hierarchical stuff, which is
all most small-scalle DBAs ever understand or use, then it runs
quickly and efficiently. If you ask it to model some valid relational
structure that doesn't map onto a hierarchical model well, then it
falls flat.

So MySQL will work fine for nearly all small web sites, whatever
they're doing, and is probably what ought to be used for them. However
saying that it will always beat SQL Server is too misleading to be
worth stating.

Andy,

Exactly what "valid relational structures" are you talking about? Both
do relational designs quite well.


--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
(e-mail address removed)
==================

 

[Jerry Stuckle]

That's a very dubious benchmark. Even MUMPS wil outperform SQL Server
for some apps on some hardware. It's not because it's "better" though,
it's because it's pitched at a smaller-scale market sector. MySQL
(less so for Postgres) is a hierarchical DB with some pretensions to a
relational facade. If you ask it to do hierarchical stuff, which is
all most small-scalle DBAs ever understand or use, then it runs
quickly and efficiently. If you ask it to model some valid relational
structure that doesn't map onto a hierarchical model well, then it
falls flat.

So MySQL will work fine for nearly all small web sites, whatever
they're doing, and is probably what ought to be used for them. However
saying that it will always beat SQL Server is too misleading to be
worth stating.

I'll add one more thing. If I wanted extra things like recursive sql,
I'd be running DB2 on Linux.

SQL Server is ok for small sites. But requires way too many resources
for a big site.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
(e-mail address removed)
==================

 

[david]

I'm not sure about the exact numbers. Also, I don't know when you have to
use GetChunk to get the data, and when you can just use the field value. A
search here would probably find better information.

(david)

 

[Martin Harran]

news:[email protected]...

[...]

And both outperform SQL Server on equivalent hardware. Let's see you run
Windows 2003 Server, SQL Server (even Express Edition), IIS, SMTP server
and the rest on 128M. Heck - you can't even boot W2K3 Server Server in
128M.

But Linux and all the rest run quite well in that.

Well, if your priority is to have your server running on 128M memory or
other low spec hardware, then fine, go with Linux, that's not the priority
for most businesses.

And bring the system up to 512M-2K and it screams.

Sorry - Windows is an OK desktop. But it makes a lousy server.

W2003 is an excellent server.

Add in SQL 2005 and Exchange Server - on decent hardware, needless to say -
and you've got a set up that will handle anything that most businesses can
through at it.

 

[Jerry Stuckle]

news:[email protected]...

[...]

And both outperform SQL Server on equivalent hardware. Let's see you run
Windows 2003 Server, SQL Server (even Express Edition), IIS, SMTP server
and the rest on 128M. Heck - you can't even boot W2K3 Server Server in
128M.

But Linux and all the rest run quite well in that.

Well, if your priority is to have your server running on 128M memory or
other low spec hardware, then fine, go with Linux, that's not the priority
for most businesses.

If your priority is to waste money on unnecessary hardware, then fine -
go with Windows. Cost and reliability are the priority for most
businesses - why do you think the vast majority of the web runs on Linux?

W2003 is an excellent server.

Add in SQL 2005 and Exchange Server - on decent hardware, needless to say -
and you've got a set up that will handle anything that most businesses can
through at it.

I've got one customer still on W2K3. With 512Mb they still don't
perform as well - even on static pages - as my Linux systems running on
128Mb.

And when you bring asp or asp.net into it, it's much slower and more
resource hungry than either Perl or PHP.

And my Linux systems cost several thousand dollars less than the
equivalent Windows systems.

+--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
(e-mail address removed)
==================

 

[Fred Atkinson]

just use SQL Server, kid

OK, where can you get this free version of SQL Server? And
how does one go about learning to use it?

Regards,



Fred

 

[Martin Harran]

OK, where can you get this free version of SQL Server?
http://msdn.microsoft.com/vstudio/express/sql/register/default.aspx

And
how does one go about learning to use it?

Plenty of stuff on included Books Online and MS site but if you've never
used SQL Server before then a book might be a good idea.