Shamil Salakhetdinov
shamil at users.mns.ru
Sun Mar 30 15:15:38 CDT 2008
<<< Would SQL Express (or similar) at the back (and housed on the server) and maybe ASP.Net at the front for all the forms and GUI stuff be the best/correct approach though? >>> Hi Darryl, SQL Express + ASP.NET 2.0 or higher - definitely correct approach IMO. Here are some stats from real live ASP.NET 2.0 app with MS SQL 2005 BE: - 688986 page hits in 75 days; - average - 9000+ page hits per day; - max case was 9 page hits per second; - min 112 page hits/day - max 44460 page hits/day - count of qty of page hits within 75 days: Page Hits/s Qty 9 2 8 13 7 40 6 194 5 655 4 3865 3 16123 2 111020 1 398276 - count of qty of page hits within day with total of 44460 page hits: Page Hits/s Qty 9 2 8 13 7 40 6 186 5 569 4 2270 3 4865 2 17929 1 20790 Resume: - ASP.NET 2.0 + MS SQL 2005 (Express) is a good choice. NB: the subject application is rather "heavyweight" - multi-layer one with multiple classlib DLLs etc. As far as I got your application is planned to be not that heavyweight - go for ASP.Net 2.0 or higher and SQL Express or MS Access BE.... -- Shamil -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darryl Collins Sent: Sunday, March 30, 2008 2:14 PM To: Access Developers discussion and problem solving Subject: [AccessD] Some Advice on Web Front end and ? backend Hi folks, My partner runs a business and wants me to whip up a database for her client data etc. (heh -dead easy right!). I originally put one together in Excel several years back which did the job, but hey, it's Excel and now the business is growing it really need to move to a better platform. I did a rebuild in Access late last year to see how it would all work, but I really am not sure Access is the way to go given her requirements - I just didn't know any better at the time, and I wanted to learn more about Access as well. Given she has 3 locations (clinic 1, clinic 2 and home) plus a numerous staff who work in a similar way I was thinking that using her website would be a good place to put the backend so it would easily accessable to all authorised people. I guess ideally she needs a server and WAN, but that isn't going to be happening soon. I was thinking something like a secure area via her URL that the staff can log into online and then access the forms, update the data etc would be pretty darn handy for her. Would SQL Express (or similar) at the back (and housed on the server) and maybe ASP.Net at the front for all the forms and GUI stuff be the best/correct approach though? I did build her current website, but I used frontpage (urrrgh) & HTML and it is all very 1994 in style and functionality!! (that said, both her and her clients like it as it is simple and easy to get around - go figure). My skills ASP.net and SQL Server almost zero at present - although the MS site provides some great training resources which I have skimmed over. If I take this path it is going to be a fun learning exercise I suspect. I have downloaded both ASP.net and SQL Express from MSoft, but haven't really had time to play around too much (oh - did i mention I have a 6 month old kid??!! hmmm...). Anyway, If you guys and gals have any suggestions, war stories, gotachas or general advice I would love to hear from you before I get too far down any one path. Definately open to ideas on this one. her current website is http://www.sprouttherapyservices.com.au/ for those who want a trip back in style time! ;) Many thanks Darryl. This email and any attachments may contain privileged and confidential information and are intended for the named addressee only. If you have received this e-mail in error, please notify the sender and delete this e-mail immediately. Any confidentiality, privilege or copyright is not waived or lost because this e-mail has been sent to you in error. It is your responsibility to check this e-mail and any attachments for viruses. No warranty is made that this material is free from computer virus or any other defect or error. Any loss/damage incurred by using this material is not the sender's responsibility. The sender's entire liability will be limited to resupplying the material. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com