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

On 3 May, 12:58, ship wrote:
Dreamweaver8, Windows XP Pro (SP2), Homesite and msAccess (2000)

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

Stop using Dreamweaver.

Use decent CSS, and put it in an external stylesheet (even if it's
still in the email it's no longer in the HTML and so doesn't need to
be stored in the database in the same field).

Although you didn't give us a URL to your HTML, any page that's 55k of
HTML source and is still short enough when rendered to be remotely
useful as a terse marketing email has to count as bloated coding.

"Jerry Stuckle" wrote in message
. ..
Aaron Kempf wrote:
just use SQL Server, kid


[...]

And why should he waste several thousand dollars on it? Rather, MySQL or
PostGres SQL will do the job he needs, and for free.

SQL Server Express edition is also free

Aaron Kempf wrote:
SQL Server is 'more free than mySql or postgres'


"Jerry Stuckle" wrote in message
. ..
Aaron Kempf wrote:
just use SQL Server, kid




"ship" wrote in message
ups.com...
Dreamweaver8, Windows XP Pro (SP2), Homesite and msAccess (2000)

Hi


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


We are trying to use msAccess to create a slightly large email
(souce code is about 55KB and Access wont save it to a Memo field
because it is too large!)


With thanks


Ship
Shiperton Henethe


And why should he waste several thousand dollars on it? Rather, MySQL
or PostGres SQL will do the job he needs, and for free.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.

==================



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.

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).

And BTW - both MySQL and PostGres SQL on Linux run just great in 128M of
RAM - and for a low volume site you have RAM to spare. You can't even
boot the latest MS OS's in 128M - at least an not be paging yourself to
death.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.

==================

Aaron Kempf wrote:
what's wrong with Dreamweaver, kid?

Access MDB is the problem-- not dreamweaver

Move to SQL Server and keep dreamweaver!



"Andy Dingley" wrote in message
oups.com...
On 3 May, 12:58, ship wrote:
Dreamweaver8, Windows XP Pro (SP2), Homesite and msAccess (2000)
Anyone know of a good/quick (and free) way to compress HTML code?
Stop using Dreamweaver.

Use decent CSS, and put it in an external stylesheet (even if it's
still in the email it's no longer in the HTML and so doesn't need to
be stored in the database in the same field).

Although you didn't give us a URL to your HTML, any page that's 55k of
HTML source and is still short enough when rendered to be remotely
useful as a terse marketing email has to count as bloated coding.




Now I understand why you push SQL Server. You don't even know what's
wrong with Dreamweaver...


--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.

==================

Aaron Kempf wrote:

just use SQL Server, kid

He may wish to keep it in Access. I know that I have a client that
downloads the Access database to work on it, not something you can do
with any other database and keep any special formatting/field types.
This may not even be on the web!

BTW, MySQL runs beautifully on windows.

Jeff




"ship" wrote in message
ups.com...

Dreamweaver8, Windows XP Pro (SP2), Homesite and msAccess (2000)

Hi


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


We are trying to use msAccess to create a slightly large email
(souce code is about 55KB and Access wont save it to a Memo field
because it is too large!)


With thanks


Ship
Shiperton Henethe

"Jerry Stuckle" wrote in message
. ..

[...]

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.

On 16 May, 01:47, Jerry Stuckle wrote:

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.

On 16 May, 11:24, Jerry Stuckle wrote:

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 ****-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.

Martin Harran wrote:
"Jerry Stuckle" wrote in message
. ..

[...]

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.

==================

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 wrote:
"ship" wrote in message
ups.com...
Dreamweaver8, Windows XP Pro (SP2), Homesite and msAccess (2000)

Hi

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

We are trying to use msAccess to create a slightly large email
(souce code is about 55KB and Access wont save it to a Memo field
because it is too large!)

I thought the limit for a memo field was nearer 65K? (But there is not point
in quibbling over where the limit is if you know you are hitting it.)

I think if you change the way you are accessing the memo field and use DAO
to access it then the limit disappears. An alternative is to use an "OLE
Object" type, but then you'll definitely need to drive it through code. So
whilst both of these will give you a way forward, neither are quick.