William Hindman
wdhindman at dejpolsystems.com
Sat Dec 15 19:24:33 CST 2007
Shamil ...wish I could help you but I'm still asking questions on the asp.net forum's beginners board :) ...and so far, all my data is read only and I cache the data using asp.net rather than SQL Server ...I've been playing with SSE and will move to it sooner than later but at the moment, you're speaking greek to me ...not that I usually understand half the stuff you get into :) ...actually, I'd feel mighty proud of myself if I understood 10% of the stuff you do ...took me a year to figure out "with events" after you and jc started preaching its virtues :( William ----- Original Message ----- From: "Shamil Salakhetdinov" <shamil at users.mns.ru> To: "'Access Developers discussion and problem solving'" <accessd at databaseadvisors.com> Sent: Saturday, December 15, 2007 3:15 PM Subject: Re: [AccessD] Access or SQL Server Express to web > William, > > I fact I didn't question/curious about what you have as a back-end - what > I > do wanted to talk about did you ever experience what is called "race > condition"? - I mean multi-threading issues when you have some shared data > (cached) in memory and several threads - several sessions of different > users > - are trying to use these data? I'm not talking about system Cache - it > synchronizes/serializes parallel access - I mean custom shared (static) > read/write data - did you ever need it? > > Also I guess because you're mainly using MS Access you should have some > kind > of "virtual locks" to prevent parallel threads/sessions update the same > data? > > Do you use System.Transactions.TransactionScope? > > I cannot find also good info on how to properly get expired sessions to > fire > event (using Global.asax?) to get this expired session's cached data to be > cleared out and related system Cache data to be cleared also... > > Have you seen/used in your project such information? > > Thanks. > > -- > Shamil > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William Hindman > Sent: Friday, December 14, 2007 7:34 AM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] Access or SQL Server Express to web > > ...I know this will get your goat but we've had over 150 users in mdb > sourced pages simultaneously without a hick-up so far ...I'm in the > process > of moving to SQL Server because the load will get much larger in the next > few months but so far, Drew has been right, Access mdbs can take a lot of > abuse on the web ...of course I'll freely admit that its read only and I > cache the hell out of it ...but still :) > > ...the web based apps all are hosted on shared win2K3 boxes w plenty of > ram > and dedicated app spaces. > > ...the largest intranet based app never has more than ten users in it and > the average is probably less than five ...the servers are all Dell PE's w/ > 2GB ram and large Raid5 HDs running SBS2003 Premium R2 ...pretty vanilla > but > > I like vanilla in servers :) > > ...like I said, I cater to small business owners and tend to keep it > simple > ...something an ignorant lout like me can stay on top of :) > > ...btw, the MS ajax built into 3.5 works really well compared to that > added > on to 2.0 ...its a very noticeable difference imnsho, especially in the > gridview ...the MS sponsored open-source 3.5 ajax controls toolkit version > on the other hand, still has some performance problems with some of the > controls ...two steps forward, one step back. > > William > > ----- Original Message ----- > From: "Shamil Salakhetdinov" <shamil at users.mns.ru> > To: "'Access Developers discussion and problem solving'" > <accessd at databaseadvisors.com> > Sent: Thursday, December 13, 2007 4:12 PM > Subject: Re: [AccessD] Access or SQL Server Express to web > > >> <<< >> ...10Gb on a system drive on a system using asp.net and sql server? >>>>> >> Well, I have almost all programs, except Windows installed on D: and that >> one is 50Gigs... >> >> ...and all projects are on E; and that one is 30Gigs, there are several >> others... >> >> ...I know now I was wrong when I thought that 10GB would be enough for >> Windows for a long time (and I have many files already compacted on C: >> most >> the windows updates' backups deleted... >> >> <<< >> I'm not building anything nearly as large or complicated >> as you ...and never intend to :) >>>>> >> Lucky man :) >> >> What is the usual quantity of simultaneous users for your ASP.NET >> applications? >> >> What is the usual IIS/ASP.NET server PC of your customers? >> >> <<< >> ...vs'8 and 3.5 are really, really sweet ...ms has paid a lot of >> attention >> to developer feedback of late and its showing up now, imnsho. >>>>> >> Good news! I will try to switch to them ASAP in the beginning of the next >> year I hope... >> >> >> -- >> Shamil >> > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com