View previous topic :: View next topic |
Author |
Message |
kennard -
Joined: 08 Nov 2004 Posts: 4
|
Posted: Fri Jul 29, 2005 2:58 pm Post subject: ASP Paging Large records |
|
|
I hope I can explain this right, because I really need help with this.
1. I have the latest free version of Abyss Web Server.
2. My pages are developed using ASP and MySQL 4.x the latest stable version
My Problem is that my website relies heavily on the MySQL data. I have two field that are pulled for display. Everything loads really slow and the some pages get stuck in a loop I believe because of the number of records trying to display.
My fields:
prod_link (the field type is text) index as well
prod_image(the field type is text) '' '' ''
I would say that the majority of the pages load the data and page the records with no problem. (meaning if i have 40 records i display 10 records at a time per page) But page load still takes 15 -20 seconds to load sometimes longer.
I have one page that has to load about 100 records to page through. Sometime it loads the 1st page 2nd page and 3rd page but when you select the 4th page it outputs nothing. If i refresh the page maybe 4 or 5x it will load the records. All the while the page load is still very slow
My OS is Windows XP
I have a Pent III + 512MB Ram
My available RAM is about 260MB +-
PLEASE HELP !!! '~' |
|
Back to top |
|
|
aprelium -
Joined: 22 Mar 2002 Posts: 6800
|
Posted: Fri Jul 29, 2005 6:17 pm Post subject: Re: ASP Paging Large records |
|
|
kennard,
Try adding some code to your ASP pages to display the ODBC connection errors when ODBC calls fail. This may help you narrow your search and locate the problem. _________________ Support Team
Aprelium - http://www.aprelium.com |
|
Back to top |
|
|
kennard -
Joined: 08 Nov 2004 Posts: 4
|
Posted: Fri Jul 29, 2005 6:57 pm Post subject: ODBC error ??? |
|
|
I don't get any errors in my pages.
1. Just extremly slow page loads
&
2. A page that never finishs loading because PERHAPS the records in cache are to large to handle. I'm talking database fields that are text type that hold links and image links.
80+ records |
|
Back to top |
|
|
aprelium -
Joined: 22 Mar 2002 Posts: 6800
|
Posted: Sat Jul 30, 2005 12:45 pm Post subject: Re: ODBC error ??? |
|
|
kennard,
You should probably tweak your ODBC drivers parameters to make them run faster. Try also increasing the timeout of CGI scripts execution in Abyss Web Server and in ActiveHTML. _________________ Support Team
Aprelium - http://www.aprelium.com |
|
Back to top |
|
|
kennard -
Joined: 08 Nov 2004 Posts: 4
|
Posted: Mon Aug 01, 2005 4:12 am Post subject: |
|
|
Okay how do I tweak my ODBC drivers parameters?
I search the web but every thing is so broad its kind of hard to narrow down what exactly I'm trying to do. That maybe the one thing that I'm missing.
..
v
I got good results from increasing the timeout of CGI scripts execution in A.W.S and in ActiveHTML.
I pushed them both to 180 and at least the pages finish loading without timing out. |
|
Back to top |
|
|
aprelium -
Joined: 22 Mar 2002 Posts: 6800
|
Posted: Mon Aug 01, 2005 12:19 pm Post subject: |
|
|
kennard wrote: | Okay how do I tweak my ODBC drivers parameters?
I search the web but every thing is so broad its kind of hard to narrow down what exactly I'm trying to do. That maybe the one thing that I'm missing.
|
Search http://www.microsoft.com for ODBC articles and support. That's the best place to get detailed information about these components. _________________ Support Team
Aprelium - http://www.aprelium.com |
|
Back to top |
|
|
kennard -
Joined: 08 Nov 2004 Posts: 4
|
Posted: Tue Aug 02, 2005 12:32 am Post subject: ODBC |
|
|
You were right! I had to tweak my ODBC.
After searching ODBC forums I finally found a situation simular to minds
I had to turn Tracing Off in the ODBC Administrator. After that everything runs great. Tracing drains your memory and puts a drag on database querying makes your pages load very slow.
Thanks for your advice. |
|
Back to top |
|
|
|