DIW Maximum File Size?

[Mick]

Is there a recommended maximum file size (hence maxmum Access table size, and
/ or a maximum number of fields) that can be handled by the DIW. I have a
table with about 90 fields, which produces a detail.asp within the DIW of
about 250K. Thank you.

 

[Tom Miller]

"Mick"
I can't answer the question directly but...

Is there a recommended maximum file size (hence maxmum Access table size, and
/ or a maximum number of fields) that can be handled by the DIW. I have a
table with about 90 fields, which produces a detail.asp within the DIW of
about 250K.

In one of my courses on Access, the instructor said the maximum database
size was 2 gigabytes. You should also be aware that when you have more than
about 20 active connections the database slows down. So if your writing any
ASP code, you should manually open and close the connections to minimize the
total connections active at any given time. If this website is going to get
very busy you need to start thinking about going to a database that will
handle more connections rapidly (eg: MS Sql or MySql or something).

Respectfully,
Tom Miller

 

[Mick]

Hi Tom, many thanks. The database is only tiny really, I see the max size as
5mb. Perhaps you may also know, is it possible for more than one person to be
running the "update" query via the "edit.asp" page in the Database Interface
Wizard n frontpage at the same time, perhaps working on different records, or
should I assress that one to the FrontPage forum?

 

[Andrew Murray]

This is the Frontpage forum.....

Hi Tom, many thanks. The database is only tiny really, I see the max size
as
5mb. Perhaps you may also know, is it possible for more than one person to
be
running the "update" query via the "edit.asp" page in the Database
Interface
Wizard n frontpage at the same time, perhaps working on different records,
or
should I assress that one to the FrontPage forum?

 

[Tom Miller]

This is the Frontpage forum.....

I'm sorry Andrew. I don't understand. If the question is about the Database
wizard of FP and the database (which is the Jet DB engine used by Access)
then why is it "off-topic"?

Thanks,
Tom Miller

 

[Tom Miller]

.. Perhaps you may also know, is it possible for more than one person to be

running the "update" query via the "edit.asp" page in the Database Interface
Wizard n frontpage at the same time, perhaps working on different records, or
should I ask that one to the FrontPage forum?

Mick,
I am not an expert on the Database Wizard. I am not sure how the DIW goes
about doing the record or database locking to allow multiple users to access
the DB at the same time.

Best practice is to open any/all records as "read only" and to very briefly
open for "read/write" just as the program needs to update a record and then
immediately close that record again. So if best practices were coded, it
should be possible for more than one user to be updating the DB at the same
time but it will not be possible for 2 users to update the same record at
the same time.

It gets messy when you do. The 2nd user using the older record updates over
the top of the newer record reverting the DB to the older record with the
2nd users changes. This is a major head-ache in DB design/programming.
Lots of books/words expended on it.

The other thing to remember is if this site and the database update
frequency gets above a very modest level, your ISP will want you to upgrade
to a faster/more powerful DB product.

Hope that helps,
Tom Miller
--

 

[Tom Miller]

....

This is the Frontpage forum.....

Andrew,
I appologize all over myself. I was reading messages out of sequence and
didn't understand your reference. I now understand you were referring to
Mick's message where he said roughly "....maybe I should talk about this in
the FP forum...." <slapped forhead> Anyway, SORRY!

Tom (opps!) Miller
--

 

[Mick]

Thanks to Tom & Andrew, sorry I posted the same text to both forum, hence the
confusion. All questions answered ( and some I had not got to yet!) many
thanks Mick

 

[Thomas A. Rowe]

The detail.asp page size is controlled by the way FP write the ASP script. If you learn to hand code
and not rely on FP to write the script you can reduce the size at least by 70%, if not more.

FYI: Access on the web can handle around 6000 connections per hour, as long as you are open a single
connection in the global.asa and then opening and closing individual recordsets as needed within
your site.
--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================