Re: HELP Access DB, ASP.NET 2.0 and whole lot of pain
- From: "Patrice" <nobody@xxxxxxxxxxx>
- Date: Tue, 6 Dec 2005 17:11:21 +0100
It's also your job to warn your boss when he asks for something that is just
not possible. As a side note, Jet is limited AFAIK to 2 Go (that is you'll
be able to store only 20 files of 100 Mo each). IMO you'll have a similar
limit with MSDE.
Even with a more appropriate DB I would still discuss this requirement. Does
he have a legimate expectation for storing the files in the DB ?
--
Patrice
"MikeJingJing" <MikeJingJing@xxxxxxxxxxxxxxxxxxxxxxxxx> a écrit dans le
message de news:6EEABE53-C00F-4655-B4B5-7FD9E918EC12@xxxxxxxxxxxxxxxx
> Hey Grant.. yes I am trying to store a file over 50 megs into the
database..
> I see where you are going with your suggestion but as the boss says, "it
> needs to be done" .. heh unfortunately the file NEEDS to be stored IN the
> database and the file can't reside elsewhere ...
>
> does anyone know a fatal flaw that i'm missing here? any other
suggestions?
> .. thanks Grant btw.. hah
>
>
>
> "Grant Merwitz" wrote:
>
> > Are you trying to store the file in your Access database?
> > Of over 50 megs a file???
> >
> > That sounds like madness :-D
> >
> > Why don't you save the file on your your server, and a reference to that
> > files location in your database
> >
> > "MikeJingJing" <MikeJingJing@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> > news:C1BF674D-E7E9-4E18-B4B3-A74D9D83D5AC@xxxxxxxxxxxxxxxx
> > > Hi everyone ok I have 2 serious problems.. Firstly a little background
is
> > > that i'm using ASP.NET 2.0 (obviously with the 2.0 Framework) with an
> > > Access
> > > Database.
> > >
> > > In my Web App i have an upload feature and I've discovered that if i
> > > upload
> > > anything below 25 Meg it uploads in a reasonable time (less than 1
min) if
> > > i
> > > upload anything above 50 megs when we're talking a big time wait ...
for
> > > example a 100 meg file i uploaded took almost 10 min. Now i've
recently
> > > discovered the reason for the wait is because of the slow writing to
the
> > > database, the file actually uploads really quickly But 99% of the time
is
> > > spent writing to the Access Database.. i dont' know the reason but it
> > > seems
> > > that the greater the file size it tries to write the longer it takes
(the
> > > wait almost seems to increse exponentially).
> > >
> > > The second problem with this is that while the upload is still writing
the
> > > data to the database other computers (or instances) cannot access the
web
> > > app because it seems that it is doing some kinda of heavy processing..
> > > only
> > > when the web app finished writing was i able to access the
application.
> > > Now
> > > to clarify, on the second workstation when iwas accessing the web
server I
> > > was trying to 'login' which requires an access to ANOTHER database ..
> > >
> > > My friend tells me my post is too long.. but if anyone has any ideas
or
> > > needs more info please lemme know.. thanks
> > >
> > > MikeJingJing
> > >
> >
> >
> >
.
- References:
- Re: HELP Access DB, ASP.NET 2.0 and whole lot of pain
- From: Grant Merwitz
- Re: HELP Access DB, ASP.NET 2.0 and whole lot of pain
- Prev by Date: Re: Downloaded document has disappeared by the time Word has opene
- Next by Date: Re: Help - client side validation not working, driving me MAD!
- Previous by thread: Re: HELP Access DB, ASP.NET 2.0 and whole lot of pain
- Next by thread: BUG: Microsoft Visual Web Developer 2005 Express Edition
- Index(es):
Relevant Pages
|
