My website has HTML and ASP codes, using database of MS ACCESS.
When i surf html coded pages, its content comes out very quickly, however,
with asp codes, it takes more than 30 seconds to see one page.
I think it happens because asp pages are looking through mdb file
everytime(though they have to).
So, is there any way to show text content on browser first and load DB while
people read things on the page? 8 1257
"=?Utf-8?B?UGhpbA==?=" <Ph**@discussions.microsoft.com> confessed in
news:D6**********************************@microsof t.com: My website has HTML and ASP codes, using database of MS ACCESS. When i surf html coded pages, its content comes out very quickly, however, with asp codes, it takes more than 30 seconds to see one page.
I think it happens because asp pages are looking through mdb file everytime(though they have to).
So, is there any way to show text content on browser first and load DB
while people read things on the page?
Yes, you can unbuffer the page and organize so that something static displays
before the data.
But, why is it taking 30 seconds to retrieve data? That is an unacceptable
wait time for users.
Perhaps you can break this data up or examine your code and optimize?
-- ipgrunt
On 26 Jan 2005 19:35:27 GMT, IPGrunt <me@privacy.net> wrote: "=?Utf-8?B?UGhpbA==?=" <Ph**@discussions.microsoft.com> confessed in news:D6**********************************@microso ft.com:
My website has HTML and ASP codes, using database of MS ACCESS. When i surf html coded pages, its content comes out very quickly, however, with asp codes, it takes more than 30 seconds to see one page.
I think it happens because asp pages are looking through mdb file everytime(though they have to).
So, is there any way to show text content on browser first and load DB while people read things on the page?
Yes, you can unbuffer the page and organize so that something static displays before the data.
But, why is it taking 30 seconds to retrieve data? That is an unacceptable wait time for users.
Perhaps you can break this data up or examine your code and optimize?
-- ipgrunt
30 Seconds is a bit crazy even for an MDB.
I've have seen speeds similar before though on shared servers that are
under seriously heavy load.
Is it running on a shared server? Does it run at a different speed
when you run it locally?
If it's that speed locally as well then there is something madly wrong
with the code.
You can use Response.Flush to get stuff chucked to the broswer while
the page continues to be interpreted.
Be aware though if you are flushing inside a table tag nothing will be
flushed until /table is reached as the browser doesn't like to render
half a table.
You can help track down which part of the code is causing the slowness
by using the Timer function. It returns the number of seconds since
midnight.
So at the begining of the page have something like
Dim iStartTime
iStartTime = Timer
Then throughout your code at each point you want a time displayed
chuck in the following:
Response.Write "<p style=""color:red"">" & Timer - iStartTime & "
seconds passed</p>" : Response.Flush
It's not super accurate but we are talking 30 seconds here it won't
matter!
--
Iain Norman | http://www.eliteforum.org
> My website has HTML and ASP codes, using database of MS ACCESS. When i surf html coded pages, its content comes out very quickly, however, with asp codes, it takes more than 30 seconds to see one page.
Code is like water. It's always singular...
I think it happens because asp pages are looking through mdb file everytime(though they have to).
I think it could be any number of things. It could be the connection speed
of the computer, the amount of traffic on the server, virus software running
on the server, some other server issue, or your "codes." I think I would
look at the last first.
--
HTH,
Kevin Spencer
Microsoft MVP
..Net Developer
Neither a follower nor a lender be.
"Phil" <Ph**@discussions.microsoft.com> wrote in message
news:D6**********************************@microsof t.com... My website has HTML and ASP codes, using database of MS ACCESS. When i surf html coded pages, its content comes out very quickly, however, with asp codes, it takes more than 30 seconds to see one page.
I think it happens because asp pages are looking through mdb file everytime(though they have to).
So, is there any way to show text content on browser first and load DB while people read things on the page?
Let me elaborate a bit. Working with databases is expensive. Your remark
that "asp pages are looking through mdb file everytime(though they have to)"
indicates an assumption ("they have to") that is probably untrue. Effective
use of caching is important. Good code is also important overall.
BTW, the ASP database newsgroup is microsoft.public.inetserver.asp.db.
--
HTH,
Kevin Spencer
Microsoft MVP
..Net Developer
Neither a follower nor a lender be.
"Phil" <Ph**@discussions.microsoft.com> wrote in message
news:D6**********************************@microsof t.com... My website has HTML and ASP codes, using database of MS ACCESS. When i surf html coded pages, its content comes out very quickly, however, with asp codes, it takes more than 30 seconds to see one page.
I think it happens because asp pages are looking through mdb file everytime(though they have to).
So, is there any way to show text content on browser first and load DB while people read things on the page?
re: Code is like water. It's always singular...
My mouth waters whenever anybody mentions ice cream.
;-)
Juan T. Llibre
ASP.NET MVP
===========
"Kevin Spencer" <ke***@DIESPAMMERSDIEtakempis.com> wrote in message
news:e$**************@TK2MSFTNGP09.phx.gbl... Code is like water. It's always singular...
That is a verb, Juan. You're comparing apples with oranges.
--
HTH,
Kevin Spencer
Microsoft MVP
..Net Developer
Neither a follower nor a lender be.
"Juan T. Llibre" <no***********@nowhere.com> wrote in message
news:el**************@TK2MSFTNGP14.phx.gbl... re: Code is like water. It's always singular...
My mouth waters whenever anybody mentions ice cream.
;-) Juan T. Llibre ASP.NET MVP =========== "Kevin Spencer" <ke***@DIESPAMMERSDIEtakempis.com> wrote in message news:e$**************@TK2MSFTNGP09.phx.gbl... Code is like water. It's always singular...
Not to argue, but as a noun
it can be used in the plural, too :
There's 44,100 references to "sea waters" at Google : http://www.google.com/search?as_q=&n...h=&safe=images
There's also usage like "territorial waters" a plural noun which stands
for the area of sea near a country's coast and under its legal control.
And there's also "to fish in troubled waters", also a plural noun.
And there's also "to pour oil on troubled waters", also a plural noun.
See http://dictionary.cambridge.org/resu...rchword=waters
for more examples of usage of "waters" as a noun.
But, this is terrible thread-drift.
Sorry for the thread tangent topic.
Juan T. Llibre
ASP.NET MVP
===========
"Kevin Spencer" <ke***@DIESPAMMERSDIEtakempis.com> wrote in message
news:%2****************@TK2MSFTNGP15.phx.gbl... That is a verb, Juan. You're comparing apples with oranges.
-- HTH,
Kevin Spencer Microsoft MVP .Net Developer Neither a follower nor a lender be.
"Juan T. Llibre" <no***********@nowhere.com> wrote in message news:el**************@TK2MSFTNGP14.phx.gbl... re: Code is like water. It's always singular...
My mouth waters whenever anybody mentions ice cream.
;-) Juan T. Llibre ASP.NET MVP =========== "Kevin Spencer" <ke***@DIESPAMMERSDIEtakempis.com> wrote in message news:e$**************@TK2MSFTNGP09.phx.gbl... Code is like water. It's always singular...
Okay, okay, now we've completely obliterated the meaning of what I was
trying to say. So, what say you - "code" or "codes?"
--
HTH,
Kevin Spencer
Microsoft MVP
..Net Developer
Neither a follower nor a lender be.
"Juan T. Llibre" <no***********@nowhere.com> wrote in message
news:eW**************@TK2MSFTNGP11.phx.gbl... Not to argue, but as a noun it can be used in the plural, too :
There's 44,100 references to "sea waters" at Google : http://www.google.com/search?as_q=&n...h=&safe=images
There's also usage like "territorial waters" a plural noun which stands for the area of sea near a country's coast and under its legal control.
And there's also "to fish in troubled waters", also a plural noun. And there's also "to pour oil on troubled waters", also a plural noun.
See http://dictionary.cambridge.org/resu...rchword=waters for more examples of usage of "waters" as a noun.
But, this is terrible thread-drift. Sorry for the thread tangent topic. Juan T. Llibre ASP.NET MVP =========== "Kevin Spencer" <ke***@DIESPAMMERSDIEtakempis.com> wrote in message news:%2****************@TK2MSFTNGP15.phx.gbl... That is a verb, Juan. You're comparing apples with oranges.
-- HTH,
Kevin Spencer Microsoft MVP .Net Developer Neither a follower nor a lender be.
"Juan T. Llibre" <no***********@nowhere.com> wrote in message news:el**************@TK2MSFTNGP14.phx.gbl... re: Code is like water. It's always singular...
My mouth waters whenever anybody mentions ice cream.
;-) Juan T. Llibre ASP.NET MVP =========== "Kevin Spencer" <ke***@DIESPAMMERSDIEtakempis.com> wrote in message news:e$**************@TK2MSFTNGP09.phx.gbl...
Code is like water. It's always singular...
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Arpan |
last post by:
Microsoft, in one of its "Help & Support" pages on ADO, says that a
System DSN is three times faster than a File DSN. I find that a bit odd
for the simple reason that won't it be faster for a...
|
by: Danny |
last post by:
I am trying to process a database and my code does so much that it takes a
whle to go through the database.
most of it is sql queries, updates and such.
For about 6000 records, it takes over a...
|
by: Danny Dy |
last post by:
Hi To All,
I always write My VBA code in SQL(see Example).
Private Sub cbxAEName_NotInList(NewData As String, Response As Integer)
Dim stSQL as String
Dim strMsg As String
strMsg = "'" &...
|
by: Willem |
last post by:
Looking for some opinions on alternatives to programming with Access.
I find that quite often I need to loop through my recordsets (first to
last) performing calculations and was wondering if...
|
by: MLH |
last post by:
I have a table I can open as table type
recordset or a dynaset. Searching for
a particular value in the table's main
keyfield, which would be faster and
less strain on the application......
|
by: James dean |
last post by:
I done a test and i really do not know the reason why a jagged array who
has the same number of elements as a multidimensional array is faster
here is my test. I assign a value and do a small...
|
by: Lyle Fairfield |
last post by:
II first noticed this phenomenon in Access 2003. Simply stated it is:
The second loop is faster than the first loop.
That is if we test:
Not (a Or b) against (Not a) And (Not b)
in a loop of...
|
by: ctman770 |
last post by:
Hi Everyone,
Is it faster to save the precise location of an html dom node into a
variable in js, or to use getElementById everytime you need to access
the node?
I want to make my application...
|
by: shuisheng |
last post by:
Dear all,
Would you please tell me when using pointer and not using pointer,
which is faster to access data? Such as
float *pVal
float val
MyClass *pA pA->member1
MyClass a ...
|
by: Ganesh |
last post by:
Hi,
This is a question that pertains to pointers in general (C or C++).
Which of the following is faster and why?
for (int i = 0; i < N; i++)
= ... a...
(or)
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
| |