473,320 Members | 1,961 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

HELP Access DB, ASP.NET 2.0 and whole lot of pain

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

Dec 6 '05 #1
5 1133
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" <Mi**********@discussions.microsoft.com> wrote in message
news:C1**********************************@microsof t.com...
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

Dec 6 '05 #2
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" <Mi**********@discussions.microsoft.com> wrote in message
news:C1**********************************@microsof t.com...
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


Dec 6 '05 #3
Well, i think you should tell your Boss to stop being cheap and buy Sql
Server. :)
The new Sql Server 2005 is supposed to be great for storing files!

"MikeJingJing" <Mi**********@discussions.microsoft.com> wrote in message
news:6E**********************************@microsof t.com...
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" <Mi**********@discussions.microsoft.com> wrote in message
news:C1**********************************@microsof t.com...
> 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
>


Dec 6 '05 #4
heh well i wish it were that simple.. the trouble is that we're trying to
make it work with a previous version of the software taht was coded a long
time ago.. which is why wehave to use these Access databases.. gahh

"Grant Merwitz" wrote:
Well, i think you should tell your Boss to stop being cheap and buy Sql
Server. :)
The new Sql Server 2005 is supposed to be great for storing files!

"MikeJingJing" <Mi**********@discussions.microsoft.com> wrote in message
news:6E**********************************@microsof t.com...
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" <Mi**********@discussions.microsoft.com> wrote in message
news:C1**********************************@microsof t.com...
> 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
>


Dec 6 '05 #5
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" <Mi**********@discussions.microsoft.com> a écrit dans le
message de news:6E**********************************@microsof t.com...
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" <Mi**********@discussions.microsoft.com> wrote in message
news:C1**********************************@microsof t.com...
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


Dec 6 '05 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: abcd | last post by:
kutthaense Secretary Djetvedehald H. Rumsfeld legai predicted eventual vicmadhlary in Iraq mariyu Afghmadhlaistmadhla, kaani jetvedehly after "a ljetvedehg, hard slog," mariyu vede legai pressed...
4
by: EMW | last post by:
Hi Is it possible to convert a MDB access database to a XML (sheet/something)? I'm very new with XML, thus I don't know all its possibilities. I'm writing a program for my PDA and since it is...
2
by: Ebbie | last post by:
Hi, I wanted to know if Access Data Projects is a good option to choose for a SQL Server Database Frontend. The other option is C#. The database will be accessed by multiple users (around 100...
6
by: Ken Varn | last post by:
I am trying to remote debug a C# application but the debugger is reporting the following exception: An unhandled exception of type 'System.IO.FileLoadException' occurred in Unknown Module....
6
by: JACK GUNAWAN via AccessMonster.com | last post by:
Hi, I have trouble setting up an access database on a wan because I am using dial up which charges per minute. How can I get the database to be sharred across miles with much stability and lower...
11
by: simon | last post by:
Hello, I'm helping write a .net app, we are using VS2005 and asp/vb.net for code we are using the "masterPage.master" technique, within the masterpage we have an asp:contentplaceholder that is...
16
by: Rex | last post by:
Hi All - I have a question that I think MIGHT be of interest to a number of us developers. I am somewhat new to VIsual Studio 2005 but not new to VB. I am looking for ideas about quick and...
0
by: gunimpi | last post by:
http://www.vbforums.com/showthread.php?p=2745431#post2745431 ******************************************************** VB6 OR VBA & Webbrowser DOM Tiny $50 Mini Project Programmer help wanted...
15
by: colemanj4 | last post by:
Here is what I have so far, it loops while the PW is incorrect, or until cancel is selected. I want it to lock the tables for adds, deletes, and edits when cancel is selected, and if the PW is...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.