William Hindman
wdhindman at dejpolsystems.com
Thu Dec 13 22:33:39 CST 2007
...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 > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William Hindman > Sent: Thursday, December 13, 2007 10:44 PM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] Access or SQL Server Express to web > > ...10Gb on a system drive on a system using asp.net and sql server? > ...you've got more guts than I do :) > > ...or more likely you know a lot more than I do ...but I stopped buying > SBS > pre-installed from Dell because they did things like that ...I "waste" at > least 30Gb on the system drive and more if I have it to spare ...the nasty > thing about the system drive is that once you've formatted it ...and then > you install something that insists on using it ...its a royal bitch to > change its size without going through all sorts of conniptions ...so I > always start with at least twice as much space as I think I could possibly > ever need ...with the price of terrabyte hds these days, why not? > > ...as for asp.net chewing up resources when its compiling, I've not > noticed > it as yet but then I'm not building anything nearly as large or > complicated > as you ...and never intend to :) > > ...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. > > 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 1:29 PM > Subject: Re: [AccessD] Access or SQL Server Express to web > > >> William, >> >> I still to switch to VS8, hopefully in the beginning of the next year... >> >> Yes, working with VS5 and sophisticated .aspx pages in design mode is a >> real >> PITA. Pity MS didn't solve this issue in VS8 but after all working in >> markup >> mode is not a big issue as you noted.... >> >> I have here a rather large ASP.Net solution - it's a set of 10+ projects >> (ClassLibs) and I have to have ASP.NET part with VL classlib in one >> solution >> while all the other stuff is in another solution - and there is no other >> way >> to work with that within one ASP.NET solution because then recompile >> becomes >> rather time consuming... >> >> It's not a problem to have two solutions opened and have console test app >> to >> test the classlibs and just have ASP.NET and VL parts calling the other >> layers classlibs: when needed to debug/trace even without projects >> connected >> to the ASP.NET solution I can "dive" into source code on the lower >> layers' >> classlibs, which DLLs are referenced from ASP.NET solution - this is nice >> feature of VS5 and VS8 I think... >> >> Rather PITAful issue I'm getting here is that when recompiling/running in >> test/debug mode many times my ASP.NET solution I'm getting harddisk space >> of >> system disk degrading from about 2GB to less than 100MB! And then my W2K3 >> system "starts to complain" that system harddisk space is too low... >> >> Quitting and restarting VS5 helps and so I just wanted to ask you: did >> you >> ever experience something like considerable system disk space degradation >> when working with your ASP.NET solutions? (I though that having 2GB free >> space on System disk would be more than enough but it happens it is not >> (I >> have most of the programs installed on D: drive and when I installed the >> system I did assign total size of 10GB to my system drive and I thought >> that >> would be plenty of space for a long time but it happens it is not...) >> >> Just wanted to share some other "blues" VS5 brings sometimes... >> >> But all in all VS5, C#/VB.NET and ASP.NET and related stuff is a great >> development platform of course.... >> >> -- >> Shamil >> >> -----Original Message----- >> From: accessd-bounces at databaseadvisors.com >> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William >> Hindman >> Sent: Saturday, December 08, 2007 3:51 PM >> To: Access Developers discussion and problem solving >> Subject: Re: [AccessD] Access or SQL Server Express to web >> >> Shamil >> >> ...I've moved to vs'8 ...the intellisense in js alone is worth it ...not >> to >> mention the inclusion of a css "expression" type tool in the wd version. >> >> ...I rarely work in design mode now ...it used to crap on me all the time >> when I started using vs'5 ...its not really functional even in vs'8 >> imnsho >> ...I'd much rather work in the source window and then view the real thing >> in >> >> the browser ...and source view has notepad beat all to hell and back ...I >> can spend hours looking for the missing ":" in note pad while in vs it >> makes >> >> it virtually impossible to miss it in the first place and damned easy to >> find if you do. >> >> ...and there is sooooooooooo much more sample code available in vb.net >> and >> c#.net on the net than there is for Access ...and with the syntax being >> so >> similar between them, its often very easy to convert from one to the >> other. >> >> 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 08, 2007 5:03 AM >> Subject: Re: [AccessD] Access or SQL Server Express to web >> >> >> -- >> AccessD mailing list >> AccessD at databaseadvisors.com >> http://databaseadvisors.com/mailman/listinfo/accessd >> Website: http://www.databaseadvisors.com > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com