Database Results Pages

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?

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