ASP和'网页/网站铣削' [英] ASP and 'webpage/site milling'

问题描述

您好。


提前为长篇文章道歉。可能重复。


ASP中是否有办法处理来自访问数据库的输出，以使用文件系统对象生成html文件。
>

我找到了一个与.net相关的链接

（ http://www.asp101.com/articles/matte...ng/default.asp ）


我问的原因是这个。我有一个数据库开始增长

（可能）超出访问的性能限制，我不知道

足够（或可以负担）一份副本MS SQL。另外为了保持服务器负载下降并改善搜索引擎的性能，现在我的服务器上托管了很多网站

，我觉得磨一个静态网站会很好

每次修改数据库时，这将是一周2或3次。

也许我会在管理区域内有一个按钮来刷网站所以

这可以在深夜完成。


我想要实现的是生成以下静态

文件，它们是目前正在建立。


导航''包含''文件。数据库中左侧导航标准填充

类别。

类别列表页面，每页分成10个结果，链接指向

下一页和前一页。


单品网页。


我会将主搜索页面保留为动态ASP页面。


非常感谢任何建议或链接。我可以找到很多关于PHP的信息，但不是ASP。


TIA


Si

解决方案

Si，


您的Access表有多大？记录数量？


你有多少同步用户？ - ave和max


这些用户是更新数据库还是只是阅读？


Brian

2005年1月13日星期四19:00:01 +0000，Si

< simonATthedigitalvisionDOTcoDOTuk>写道：

ASP是否有办法处理来自访问数据库的输出，以使用文件系统对象生成html文件。


编号但是你可以用VBScript做到...... :)


（ASP是一种技术，而不是语言）

我找到了一个与.net相关的链接
（ http://www.asp101.com/articles/matte...ng/default.asp ）

我问的原因是这个。我有一个数据库开始增长（可能）超出访问的性能限制，我不知道（或能够负担得起）MS SQL的副本。


然后你想要MSDE。请参阅：

http://www.microsoft.com / sql / msde /

另外为了让服务器负载下降并改善搜索引擎的性能，我现在在我的服务器上托管了很多网站，感觉每次修改数据库时，建立一个静态站点是件好事，每周2或3次。
也许我会在管理区域内有一个按钮来刷站点所以
我想要实现的是生成以下静态文件，它们目前是即时构建的。

导航''包含''文件。数据库中左侧导航到填充的类别的标准。

类别列表页面，每页分成10个结果，链接到下一页和上一页。

单个产品网页。

我会将主搜索页面保留为动态ASP页面。

任何建议或链接都​​将不胜感激。我可以找到很多关于PHP的信息，但不能找到ASP。

这实际上都是适得其反的，你应该解决

数据库问题。如果你必须这样做，你需要跟踪更改的

数据，然后遍历一个已更改的列表，创建一个字符串

所有然后在其中的HTML代码使用

FSMO将该字符串写入文件。如果你问起你遇到问题的部分，你会得到b $ b gte帮助开发它的代码。


Jeff

Brian Staff写道：

您的Access表有多大？记录计数？


尽管桥接表正在使用中，但是包含大部分产品数据的主表甚至还是很大的b $ b。记录数不是真的那么好，平均在500到900条记录之间。

你有多少同时用户？ - 平均和最高


同时用户平均低点是10到高25，最大值通常是当谷歌等网站被索引时，那么我已经看到用户

计数有时跳到120到130.虽然计数实际上是

会话，所以这些可能不是同时连接。

这些用户是更新数据库还是只是阅读？

主数据库只有少数管理员不经常更新

用户。一般来说，用户通过购物车更改数据库

和个人资料等。虽然不是很频繁。


Si

Hi there.

Apologies in advance for the long post. and possible repetitions.

Is there a way in ASP to process the output from an access database to
generate html files using file system object.

I found a link that goes some way there with .net
(http://www.asp101.com/articles/matte...ng/default.asp)

The reason I ask is this. I have a database that is starting to grow
(possibly) beyond the performance limits of access and I don''t know
enough about (or can afford) a copy of MS SQL. Also to keep server load
down and improve on search engine performance with quite a few sites
hosted on my server now, I feel it would be good to mill a static site
everytime the database is modified, this would be 2 or 3 times a week.
Perhaps I would have a button to mill the site within the admin area so
this could be done late at night.

What I would like to achieve is to produce the following as static
files, they are currently built on the fly.

A navigation ''include'' file. Standard for of left nav to populated
categories in the database.

Category listing pages, split into 10 results per page with a link to
next and previous pages.

Single product webpages.

I would leave the main search page as a dynamic ASP page.

Any advice or links would be greatly appreciated. I can find plenty of
information for PHP, but not ASP.

TIA

Si

解决方案

Si,

How big are your Access table(s)? record counts?

How many simultaneous users do you have? - ave and max

Are these users updating the database or just reading?

Brian

On Thu, 13 Jan 2005 19:00:01 +0000, Si
<simonATthedigitalvisionDOTcoDOTuk> wrote:

Is there a way in ASP to process the output from an access database to
generate html files using file system object.
No. But you could do it with VBScript... :)

(ASP is a technology, not a language)
I found a link that goes some way there with .net
(http://www.asp101.com/articles/matte...ng/default.asp)

The reason I ask is this. I have a database that is starting to grow
(possibly) beyond the performance limits of access and I don''t know
enough about (or can afford) a copy of MS SQL.
You want MSDE then. See:

http://www.microsoft.com/sql/msde/
Also to keep server load
down and improve on search engine performance with quite a few sites
hosted on my server now, I feel it would be good to mill a static site
everytime the database is modified, this would be 2 or 3 times a week.
Perhaps I would have a button to mill the site within the admin area so
this could be done late at night.

What I would like to achieve is to produce the following as static
files, they are currently built on the fly.

A navigation ''include'' file. Standard for of left nav to populated
categories in the database.

Category listing pages, split into 10 results per page with a link to
next and previous pages.

Single product webpages.

I would leave the main search page as a dynamic ASP page.

Any advice or links would be greatly appreciated. I can find plenty of
information for PHP, but not ASP.

This is really all counter productive, and you should address the
database issues. If you must do this, you''ll need to track changed
data, then iterate through a list of what''s changed, create a string
with all the HTML code in it then write that string to a file using
FSMO. If you ask about the parts you''re having trouble with, you''ll
gte help in developing the code for it.

Jeff

Brian Staff wrote:

How big are your Access table(s)? record counts?
The main table holding most of the product data is quite large even
though bridging tables are in use. Record count is not really that
great, averaging between 500 to 900 records at any time.
How many simultaneous users do you have? - ave and max
Simultaneous users average low is 10 to high 25, the max is usually when
the site is being indexed by google et el, then I have seen the user
count jump to sometimes 120 to 130. Although the count is actually
sessions, so these probably aren''t simultaneous connections.
Are these users updating the database or just reading?

The main database is only updated infrequently by a couple of admin
users. Generally, the users changing the DB by way of the shopping carts
and profiles etc. These are not very frequent though.

Si

这篇关于ASP和'网页/网站铣削'的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！