I am developing a website using .NET 2.0 (classified style website) it
displays a series of records per page (8, using a datagrid with paging)
each record displays a thumbnail of an image that sizes about 6-7k and a
small text description of the item. The Items tamble holds now about 2500
hundred records so that´s 60+ pages. The thing is that all the page when it
load is about 175K. Of those 83K are from images the rest is the text that
makes the HTM file. It feels like the page loads verry slow (about 20 sec in
y 768 kbps internet access) so for the size of the page i guess it is not
the html and images what is making this load so slow but some of the calls I
make to de DB. What can be causing this, the main call i make to the DB is
to get the list of records but the response time is verry slow compared with
a prev version of the same website i have that uses .NET 1.1
How can I cache some of the images that make up the page, this images are
repetitive in al the results pages.
The DB access is exactly the same as in the prev version that works much
faster that this, lstAds_PageInde xChanged calls a DataBind() sub that DOES
get the entire recordset.
TIA! 1 1530
Użytkownik "TCB" <tc******@hotma il.com> napisał w wiadomo¶ci
news:Ok******** ******@TK2MSFTN GP11.phx.gbl... I am developing a website using .NET 2.0 (classified style website) it displays a series of records per page (8, using a datagrid with paging) each record displays a thumbnail of an image that sizes about 6-7k and a small text description of the item. The Items tamble holds now about 2500 hundred records so that´s 60+ pages. The thing is that all the page when it load is about 175K. Of those 83K are from images the rest is the text that makes the HTM file. It feels like the page loads verry slow (about 20 sec in y 768 kbps internet access) so for the size of the page i guess it is not the html and images what is making this load so slow but some of the calls I make to de DB. What can be causing this, the main call i make to the DB is to get the list of records but the response time is verry slow compared with a prev version of the same website i have that uses .NET 1.1
How can I cache some of the images that make up the page, this images are repetitive in al the results pages.
The DB access is exactly the same as in the prev version that works much faster that this, lstAds_PageInde xChanged calls a DataBind() sub that DOES get the entire recordset.
I suggest you turn on tracing, add few custom messages here and there and
see what causes your code to execute too slowly.
From what you say I conclude that the main problem could be the DataBind
call that gets entire resorset each time. If you think of a scalable
application, use custom paging instead. As fas as I know the only way you
get custom paging in 2.0 is to use ObjectDataSourc e (the old custom paging
model is gone, I wonder why?).
However, there is still the problem of writing smart SQL queries that get
exactly required records. If you need the idea, look at the link below. The
idea is to create a temp table and select records from it - this is still
much faster than copying whole recordset from database server to an
application server. http://www.dotnetjunkies.com/Article...BDB9B8845.dcik
I hope this helps you,
Wiktor Zychla This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: rg |
last post by:
Hello,
I use invisionboard on a bid web site (20 000 visitors each day)
But my server has high load average.
Could you help me to optimize these select command.
1)
SELECT p.*, m.id,m.name,m.mgroup,m.email,m.joined,m.avatar,m.avatar_size,m.posts,m.aim_name,m.icq_number,
|
by: Andreas Falck |
last post by:
Hi,
I ran the code below on two different versions, 4.0.14 and 4.0.16
respectively, both running RH 7.3 on intel.
In version mysql server version 4.0.14 the SELECT privelege suffices
for "optimize table", but (seemingly) the server version 4.0.16
requires INSERT as well.
Is the INSERT privelege necessary for performing optimize in mysql
|
by: Daniel |
last post by:
Hi there,
I recently came across an interesting option when right clicking on a
project (Right click on the project -> properties -> Configuration
Properties ->Build -> Optimize)
There is an option in there to optimize the code, has anyone had any
expeiance / problems with this option and were there any significant gains
in performance by turning on this setting?
|
by: Silly |
last post by:
byte Name = new byte;
uint len = (uint)Name.Length;
uint err = MyFunction(devID, out Name, out len);
When this code is run in release build with optimize code set to true, len
is evaluated to 0. If it is run with optimize code set to false, len is
evaluated as 256 (what i want).
If I add an extra line of code after declaring len, like:
|
by: Tommy |
last post by:
Hello,
i hava build a website with a few asp.net-controls(like textbox, button,
etc)
if i view them in opera-browser, the textbox-controls goes very small -- how
can i optimize them??
any suggestions?
| |
by: Reddy |
last post by:
The sql query for my datagrid returns 100, 000 records. But the datagrid
should display 20 records per page. I am using datagrid paging, but it is
taking too much time for the page to load. Is there any way I can optimize
the speed. Any sample code would be great.
Thanks,
Reddy
|
by: Huaer.XC |
last post by:
>From the following MySQL command:
EXPLAIN SELECT * FROM t1 JOIN t2 ON (t1.id = t2.id) JOIN t3 ON t3.name
= t1.name WHERE t1.id IN(123, 124);
which result is:
-------------------------------------------------------------------------------------
table type possible_key key key_len ref rows Extra
t1 const PK, name PK 4 const 10
t3 const PK PK 4 const 10
|
by: kenneth |
last post by:
I was trying to use multiple thread to optimize my following code, but
met some problems, anyone can help me?
k are initialized.
int computePot() {
int i, j;
for( i=0; i<500; i++ ) {
for( j=0; j<i-1; j++ ) {
|
by: Tom453 |
last post by:
If you are selling in foreign markets other than which speaks english,
then did you know you should have your website seen on foreign Search
engines like Google.de or yahoo.co.jp
You do not need to translate your website in German to reach web
surfers in Germany, what you need to rather do is optimize only
homepage of your website into german language and german keywords,
then your website will appear on all the keywords searched in...
|
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| |
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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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 last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |