G
Guest
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
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