Wrox Programmer Forums
|
Classic ASP Basics For beginner programmers starting with "classic" ASP 3, pre-".NET." NOT for ASP.NET 1.0, 1.1, or 2.0
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old August 26th, 2004, 12:17 AM
Friend of Wrox
 
Join Date: Jul 2004
Posts: 345
Thanks: 0
Thanked 1 Time in 1 Post
Send a message via MSN to gokul_blr Send a message via Yahoo to gokul_blr
Default ASP & Access

How reliable the ASP with MsAccess mdb with 50000 Records.

What do you suggest.


__________________
Gokulan E
 
Old August 26th, 2004, 12:30 AM
Friend of Wrox
 
Join Date: Jan 2004
Posts: 1,870
Thanks: 12
Thanked 20 Times in 20 Posts
Send a message via AIM to mat41
Default

I currently have an application that has 120,000 records in one table(Access 2000). May I say, it's running as sweet as the abs on the girl who won the 400m hurdles in Athens this morning.

I guess if we dont try and max it we will ever know. I even found out today Access can run stored procs. Just when you thnk you know...

Wind is your friend
Matt
 
Old August 26th, 2004, 12:34 AM
Friend of Wrox
 
Join Date: Jul 2004
Posts: 345
Thanks: 0
Thanked 1 Time in 1 Post
Send a message via MSN to gokul_blr Send a message via Yahoo to gokul_blr
Default

Great !!!

As long as the performance is not bad. We can work with.....

THANKS WIND


 
Old August 26th, 2004, 12:48 AM
Friend of Wrox
 
Join Date: Jan 2004
Posts: 1,870
Thanks: 12
Thanked 20 Times in 20 Posts
Send a message via AIM to mat41
Default

The type of DB used is relative to performance however smart coding and smart queries is where you save the resources. Why I believe the web pages talking to the DB described above goes well is:
connect, get recordset(s), use recordSetName.getRows(makes array(s)!!), close connection and then use the array(s) to render your page copy.

Wind is your friend
Matt
 
Old August 26th, 2004, 12:55 AM
Friend of Wrox
 
Join Date: Jan 2004
Posts: 1,870
Thanks: 12
Thanked 20 Times in 20 Posts
Send a message via AIM to mat41
Default

BTW: If a client owns a license for SQLServer I would strongly advise against Access purely for scalability. If the dataset is likely to grow immeasurably, it will fall over eventually.

You can buy a one tonne truck. If you 'ever' think you may need to carry more than one tonne, why bother with the one tonner - go for the big boy to start with.


Wind is your friend
Matt
 
Old August 26th, 2004, 01:13 AM
Friend of Wrox
 
Join Date: Jul 2004
Posts: 345
Thanks: 0
Thanked 1 Time in 1 Post
Send a message via MSN to gokul_blr Send a message via Yahoo to gokul_blr
Default

Hi Matt,

Sure for the long run & data security we will surely consider the above of looking for Data server like SQL/Oracle.

Thanks Wind


 
Old August 26th, 2004, 01:23 AM
Friend of Wrox
 
Join Date: Oct 2003
Posts: 463
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to madhukp
Default

I suspect MS Access 2000 is thread safe. I remember, I have seen some such comment in this forum some days back. Could anybody please clarify this ?
 
Old August 26th, 2004, 01:48 AM
Friend of Wrox
 
Join Date: Jan 2004
Posts: 1,870
Thanks: 12
Thanked 20 Times in 20 Posts
Send a message via AIM to mat41
Default

Reference from:
http://support.microsoft.com/default...b;en-us;299973

"When you run Microsoft Jet in an IIS environment, it is recommended that you use the native Jet OLE DB Provider in place of the Microsoft Access ODBC driver. The Microsoft Access ODBC driver (Jet ODBC driver) can have stability issues due to the version of Visual Basic for Applications that is invoked because the version is not thread safe. As a result, when multiple concurrent users make requests of a Microsoft Access database, unpredictable results may occur. The native Jet OLE DB Provider includes fixes and enhancements for stability, performance, and thread pooling (including calling a thread-safe version of Visual Basic for Applications)"

Wind is your friend
Matt
 
Old August 26th, 2004, 01:51 AM
Friend of Wrox
 
Join Date: Jan 2004
Posts: 1,870
Thanks: 12
Thanked 20 Times in 20 Posts
Send a message via AIM to mat41
Default

I just made a correction to the post 'Posted - 08/26/2004 : 4:55:39 PM' I meant to say scalability not saleability - A very big difference and perhaps the most important word in the post

Wind is your friend
Matt
 
Old August 26th, 2004, 01:56 AM
Friend of Wrox
 
Join Date: Jun 2004
Posts: 331
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to qazi_nomi
Default

Mat you said that Access can run stored procedures as wel can you tell me that how we can create and run Stored Procedues on the MS Access ?


(*_*)



Numan
--------------------------------------------------
Love is the most precious thing of this world. So find and grab it!





Similar Threads
Thread Thread Starter Forum Replies Last Post
asp 3.0 classic&access *formula retrival)? saad_rashad Classic ASP Databases 3 February 18th, 2007 03:47 PM
Access, ASP, DWMX & Search engine help. malhyp Dreamweaver (all versions) 2 August 30th, 2005 05:26 AM
MS Access & ASP c.j.rowell@ntlworld.com Classic ASP Databases 0 January 12th, 2005 02:49 PM
ASP & Outlook Web Access jolo98 Classic ASP Basics 0 October 8th, 2004 04:43 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.