http://forum.salescart.com/forum/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sat, 23 May 2026 14:22:12 +0000 Wed, 17 Mar 2004 11:22:29 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 11.04 360 forum.salescart.com/forum/RSS_post_feed.asp?TID=7 http://forum.salescart.com/forum/forum_images/web_wiz_forums.png http://forum.salescart.com/forum/ http://forum.salescart.com/forum/forum_posts.asp?TID=7&PID=12&title=database-results-pages#12 Author: mikeb
Subject: 7
Posted: March/17/04 at 11:22am

VPedofFancifuls wrote: It would cut down on resources but will the single page cause problems with the database if you have 20 or 30 people trying to access it at the same time?

The simple answer--Yes

The supposed limit for concurrent users for Access is quite low...I think 25 as I recall. I've seen 40 work but I don't recommend it. Its a single-threaded database.

If you anticipate those kind of numbers, I suggest you upgrade to SQL to ensure you don't run into problems with folks getting database too busy errors.

Edited by mike]]> Wed, 17 Mar 2004 11:22:29 +0000 http://forum.salescart.com/forum/forum_posts.asp?TID=7&PID=12&title=database-results-pages#12 http://forum.salescart.com/forum/forum_posts.asp?TID=7&PID=11&title=database-results-pages#11 Author: Techno Geek
Subject: 7
Posted: March/17/04 at 10:40am

Well it's a combination of things that may slow down the results. There are a couple of things that you should look out for.

1. How your SQL queries are written
2. What the SQL queries are looking for in the database
3. How many visitors you get on the same page, 20, 30, etc.
4. How busy the web server is

Here is a good link:
http://support.microsoft.com/default.aspx?scid=kb;en-us;q112 112
http://support.microsoft.com/?kbid=209126

Edited by Will Sani]]> Wed, 17 Mar 2004 10:40:57 +0000 http://forum.salescart.com/forum/forum_posts.asp?TID=7&PID=11&title=database-results-pages#11 http://forum.salescart.com/forum/forum_posts.asp?TID=7&PID=10&title=database-results-pages#10 Author: VPedofFancifuls
Subject: 7
Posted: March/17/04 at 10:15am

This is a question on performance with the database results function and salescart pro. I am not a programmer and am using pro3.82 and FP2000, I have been using SC for 3 years and FP for 5. I thought I would ask hoping someone has tried this already and can give me some input on their findings. Is it better to have an individual dynamic database result form for each asp page or can one use a single result page as an include page so it is easier to maintain? It would cut down on resources but will the single page cause problems with the database if you have 20 or 30 people trying to access it at the same time?]]> Wed, 17 Mar 2004 10:15:34 +0000 http://forum.salescart.com/forum/forum_posts.asp?TID=7&PID=10&title=database-results-pages#10