What are you using discountASP.net for

[bruce]

Brian,

I have seem user's application with more than 10 concurrent user using MS Access database. The determining factor though is the size of the database, if you database has plenty of rows (10000 range or more) I suggest you go with MS SQL.

You can also start with MS Access and if performance start to degrade, you can upsize your database to MS SQL.

Hope this helps.

[b]quote:Originally posted by bdwest

I am considering using discountASP.net for a client. This application would retrieve data from an on-line hydrology source and store the data in an Access database. The data is then presented to the user in either table or plot format. I have a test application at www.bwengineering.com that is hosted by dicountASP.net. I have been very please with the results but I am not sure how the application will perform under varying loads. I would find it hard to imagine that the proposed application would have any more than a 1/2 dozen users hitting the database at one time. Does anyone have any feeling or experience using an Access database in this hosting environment. I would be interested in hearing from other discountASP.net users who are using Access database applications with more than a couple of users. I know I could go to SQL server but I have much more experience with Access and the cost would be less for the client. Please feel free to email me directly if you don't like posting.

Thanks

Brian Westfall
bw@kelbli.com
</blockquote id="quote"></font id="quote">

[bdwest]

I am considering using discountASP.net for a client. This application would retrieve data from an on-line hydrology source and store the data in an Access database. The data is then presented to the user in either table or plot format. I have a test application at www.bwengineering.com that is hosted by dicountASP.net. I have been very please with the results but I am not sure how the application will perform under varying loads. I would find it hard to imagine that the proposed application would have any more than a 1/2 dozen users hitting the database at one time. Does anyone have any feeling or experience using an Access database in this hosting environment. I would be interested in hearing from other discountASP.net users who are using Access database applications with more than a couple of users. I know I could go to SQL server but I have much more experience with Access and the cost would be less for the client. Please feel free to email me directly if you don't like posting.

Thanks

Brian Westfall
bw@kelbli.com

[rhurtz]

Ya I would go with access and upgrade to sql server if the performance isn't robust enough.

Another thing to consider too is that access databases don't perform as well with you have tables with many columns, which sql server can handle better.

You could also use this project as a good experiance to get more comfortable with SQL Server... Then again I do work for DiscountASP so I might just want you to upgrade your account. [:D]

[b]quote:Originally posted by bruce

Brian,

I have seem user's application with more than 10 concurrent user using MS Access database. The determining factor though is the size of the database, if you database has plenty of rows (10000 range or more) I suggest you go with MS SQL.

You can also start with MS Access and if performance start to degrade, you can upsize your database to MS SQL.

Hope this helps.

[b]quote:Originally posted by bdwest

I am considering using discountASP.net for a client. This application would retrieve data from an on-line hydrology source and store the data in an Access database. The data is then presented to the user in either table or plot format. I have a test application at www.bwengineering.com that is hosted by dicountASP.net. I have been very please with the results but I am not sure how the application will perform under varying loads. I would find it hard to imagine that the proposed application would have any more than a 1/2 dozen users hitting the database at one time. Does anyone have any feeling or experience using an Access database in this hosting environment. I would be interested in hearing from other discountASP.net users who are using Access database applications with more than a couple of users. I know I could go to SQL server but I have much more experience with Access and the cost would be less for the client. Please feel free to email me directly if you don't like posting.

Thanks

Brian Westfall
bw@kelbli.com
</blockquote id="quote"></font id="quote">
</blockquote id="quote"></font id="quote">

---
Richard
Behind the ...[8]. .