Showing posts with label performance. Show all posts
Showing posts with label performance. Show all posts

Saturday, March 24, 2012

Serialization/Deserialization or XML as DB

Hi,
XML/web service sounds fantastic, but it is truely very very bad from
the view of performance. As long as you consider your application
performance, you should never use it under any cases. It is always bad to
serialize or deserialize a large data in XML format using disk, memory,
network or whatever. See the article entitled as Performance comparison
between SocketPro and dotNet remoting at
http://www.udaparts.com/articles/fastsocketpro.htm
DON'T USE XML/WEB SERVICE AS LONG AS YOU CONSIDER PERFORMANCE!
Yuancai (Charlie) Ye
Fast and securely accessing all of remote data sources anywhere with
SocketPro using batch/queue, asynchrony and parallel computation
See 30 well-tested and real OLEDB examples
RDB, a tool for fast and securely accessing remote databases with dial-up,
cable, DSL and wireless modems anywhere
www.udaparts.com
<umbertoeklat@dotnet.itags.org.yahoo.com> wrote in message
news:40a017dd.6118157@dotnet.itags.org.news.microsoft.com...
> as a proof of concept, am trying create a web app w/ an XML file as a
> temp DB
> What is the fastest way to do serialization/deserialization?
> or maybe the better question would be how to efficiently
> retrieve/save data to an xml file.
> have tried deserializing from XML file but having a hard time on
> mulitple records...
>
> sample codes would be nice :)
> thanksOk first of all, I think we are talking about persistence, not
serialization.
Imagine you filling a bucket with a hose. The process of the water moving
thru the hose is called as serialization, and the filling of the bucket is
called as "Persistence".
Anyway, the fastest way to do persistence, I feel is to create a class that
represents your data. The class is marked [Serializable]. Then use Binar
y
formatter to Serialize it to a memory-mapped file. A memory mapped file is
what in short the OS will take care of persistence, but it stays in RAM, so
it's ultra fast. (and easy to implement too). Now if this were a web
application, you could use advanced techniques like caching (asp.net), or
object pooling (COM interop), to get even better performance benefit. ...
man this is getting exciting as we go :).
See - thats the catch, Your proof of concept doesn't need to do XML
persistence, because Binary would be SO MUCH quicker, and then you could
obviously set [xmlelement] on each of the class's public properties, to
convert it to xml using XMLSerialization*.*, which might I add is entirely
different from BinaryFormatter, and SoapFormatter, and easily within memory
convert it to XML - should you need it - though once you have represented
your data as a serializable class - I see no need to involve XML here :).
- Sahil Malik
Independent Consultant
You can reach me thru my blog - http://dotnetjunkies.com/WebLog/sahilmalik/
<umbertoeklat@.yahoo.com> wrote in message
news:40a017dd.6118157@.news.microsoft.com...
> as a proof of concept, am trying create a web app w/ an XML file as a
> temp DB
> What is the fastest way to do serialization/deserialization?
> or maybe the better question would be how to efficiently
> retrieve/save data to an xml file.
> have tried deserializing from XML file but having a hard time on
> mulitple records...
>
> sample codes would be nice :)
> thanks

serialized binary files vs Sql Server Performance..

I'm considering deploying an application that will us an IP address locaiton
database provided by Ip2location.com...
http://www.ip2location.net/ip2locat...-component.aspx
their .net component reads data from a binary file. I'm guess i'm wondering
which of the two options would be best.
1) read data from the binary files (~27 mb or so)
2) or query a sql DB with the same info.
The database will have about 8 columns and ~ 1.8 millions rows.
i'm developing for a high traffic webisite, and i would like to query this
DB to get the City info from the DB when a visitor first visits the site
(based on their ip address).
Also, how do serialized binary files handle simultaneous file access? Would
a high traffic webisite be able to use a serialized file efficiently if the
file was read often?
Thanks!Fabuloussites wrote:
> I'm considering deploying an application that will us an IP address locait
on
> database provided by Ip2location.com...
> http://www.ip2location.net/ip2locat...-component.aspx
> their .net component reads data from a binary file. I'm guess i'm wonderi
ng
> which of the two options would be best.
> 1) read data from the binary files (~27 mb or so)
> 2) or query a sql DB with the same info.
> The database will have about 8 columns and ~ 1.8 millions rows.
> i'm developing for a high traffic webisite, and i would like to query this
> DB to get the City info from the DB when a visitor first visits the site
> (based on their ip address).
> Also, how do serialized binary files handle simultaneous file access? Wou
ld
> a high traffic webisite be able to use a serialized file efficiently if th
e
> file was read often?
> Thanks!
I don't see reading from a file as a big problem (open read-only), but
that's still a fair amount of data to parse (27MB). A database can
handle that much data easily (they can handle many GBs of data no
problem). Perhaps the best thing to do would be to benchmark both (like
say, query it 1000 times each ways and compare how much time it took)
and to do some load testing (not just 1 request after each other but
many simultaneous queries). My guess is that the results (which one
works best) will vary depending on how much traffic you have, the load
on the server as well as the load on the database server. It's hard to
predict accurately what would work best.
If you didn't need the city I'd recommend you have a look at this
article http://www.eggheadcafe.com/articles/20051109.asp which manages
to do it all in RAM (no file access or DB queries).
Actually,
you can get all this information for free without a database
by using the MSN Virtual Earth script generated by this URL:
http://local.live.com/WiFiIPService/locate.ashx
What this does is return a function, SetAutoLocateViewport, that you can use
with the MapControl.js VE Maps control. which can also be used to lookup the
city, state information.
SetAutoLocateViewport(28.5418, -81.3736, 10, false, 'Virtual Earth has
determined your location by using your computer's IP address.');
Note that the first two parameters represent the latitude and longitude of
the IPAddress represented by your REMOTE_HOST server variables.
Here's an article I did on this with more info (and a much smaller database,
in binary form as an embedded resource):
http://www.eggheadcafe.com/articles/20051109.asp
I am not familiar with how efficient their binary file lookup is, probably
the best way to find out is to ask the vendor. I suspect since they expect
high-volume usage that they've figured out how to optimize it.
Peter
--
Co-founder, Eggheadcafe.com developer portal:
http://www.eggheadcafe.com
UnBlog:
http://petesbloggerama.blogspot.com
"Fabuloussites" wrote:

> I'm considering deploying an application that will us an IP address locait
on
> database provided by Ip2location.com...
> http://www.ip2location.net/ip2locat...-component.aspx
> their .net component reads data from a binary file. I'm guess i'm wonderi
ng
> which of the two options would be best.
> 1) read data from the binary files (~27 mb or so)
> 2) or query a sql DB with the same info.
> The database will have about 8 columns and ~ 1.8 millions rows.
> i'm developing for a high traffic webisite, and i would like to query this
> DB to get the City info from the DB when a visitor first visits the site
> (based on their ip address).
> Also, how do serialized binary files handle simultaneous file access? Wou
ld
> a high traffic webisite be able to use a serialized file efficiently if th
e
> file was read often?
> Thanks!
Thanks for the useful information. I was not aware of the localive service.
However, i've notice that i'm getting a consistent "Server currently busy,
Try again Later" message. Is there a commercial web service that will be
more reliable? Will this web service remain free?
thanks!
"Peter Bromberg [C# MVP]" wrote:
> Actually,
> you can get all this information for free without a database
> by using the MSN Virtual Earth script generated by this URL:
> http://local.live.com/WiFiIPService/locate.ashx
> What this does is return a function, SetAutoLocateViewport, that you can u
se
> with the MapControl.js VE Maps control. which can also be used to lookup t
he
> city, state information.
> SetAutoLocateViewport(28.5418, -81.3736, 10, false, 'Virtual Earth has
> determined your location by using your computer's IP address.');
> Note that the first two parameters represent the latitude and longitude of
> the IPAddress represented by your REMOTE_HOST server variables.
> Here's an article I did on this with more info (and a much smaller databas
e,
> in binary form as an embedded resource):
> http://www.eggheadcafe.com/articles/20051109.asp
> I am not familiar with how efficient their binary file lookup is, probably
> the best way to find out is to ask the vendor. I suspect since they expect
> high-volume usage that they've figured out how to optimize it.
> Peter
> --
> Co-founder, Eggheadcafe.com developer portal:
> http://www.eggheadcafe.com
> UnBlog:
> http://petesbloggerama.blogspot.com
>
>
> "Fabuloussites" wrote:
>
i found info on the live local service. Looks like it is still in beta
format.
http://download.microsoft.com/downl...iveLocalFAQ.doc
thanks for the info. i think i will try to get access to a sample database
and use your methods to make my own binary files. their component only work
s
with dot net 1.x and i want to use a 2.0 app.
thanks!
"Fabuloussites" wrote:
> Thanks for the useful information. I was not aware of the localive servic
e.
> However, i've notice that i'm getting a consistent "Server currently busy,
> Try again Later" message. Is there a commercial web service that will be
> more reliable? Will this web service remain free?
> thanks!
> "Peter Bromberg [C# MVP]" wrote:
>
If it's only 27mb, why not just read the whole thing and put it in memory?
"Fabuloussites" <Fabuloussites@.discussions.microsoft.com> wrote in message
news:D3FEF3C4-5341-40CD-BE58-A8B915B4DB6B@.microsoft.com...
> I'm considering deploying an application that will us an IP address
> locaiton
> database provided by Ip2location.com...
> http://www.ip2location.net/ip2locat...-component.aspx
> their .net component reads data from a binary file. I'm guess i'm
> wondering
> which of the two options would be best.
> 1) read data from the binary files (~27 mb or so)
> 2) or query a sql DB with the same info.
> The database will have about 8 columns and ~ 1.8 millions rows.
> i'm developing for a high traffic webisite, and i would like to query this
> DB to get the City info from the DB when a visitor first visits the site
> (based on their ip address).
> Also, how do serialized binary files handle simultaneous file access?
> Would
> a high traffic webisite be able to use a serialized file efficiently if
> the
> file was read often?
> Thanks!
As mentioned before, i'm really new to this type of situation. So, i was
just trying to get some input regaring the performance of using a binary
file, vs a SQL server.
"PJ" wrote:

> If it's only 27mb, why not just read the whole thing and put it in memory?
> "Fabuloussites" <Fabuloussites@.discussions.microsoft.com> wrote in message
> news:D3FEF3C4-5341-40CD-BE58-A8B915B4DB6B@.microsoft.com...
>
>
either way it's a wash if you just cache the information and code something
to update the cache every...what...day? how often does city state
information change?
"Fabuloussites" <Fabuloussites@.discussions.microsoft.com> wrote in message
news:83853729-F280-4CE6-A619-8E1EAA662751@.microsoft.com...
> As mentioned before, i'm really new to this type of situation. So, i was
> just trying to get some input regaring the performance of using a binary
> file, vs a SQL server.
> "PJ" wrote:
>
I see you point. my concern is that i'm going to query this data for every
visitor to the website to determine what content to show them. So, this inf
o
will be queried when a user first visits the site to obtain the city/state
info and store it in a cookie or something. So, i was not sure how accessin
g
1.8 million rows of data would impact the performace if the site had high
traffic.
"PJ" wrote:

> either way it's a wash if you just cache the information and code somethin
g
> to update the cache every...what...day? how often does city state
> information change?
>
> "Fabuloussites" <Fabuloussites@.discussions.microsoft.com> wrote in message
> news:83853729-F280-4CE6-A619-8E1EAA662751@.microsoft.com...
>
>
A properly setup database will perform better, I believe.
But testing is the only way to check for sure.
..
You need to properly index the table, esp with that many rows.
The addage of "if the column is in the where clause, then index it" may
not be sufficient here. You need to determine the exact query usage.
www.sqlservercentral.com would be a good resource for that kind of sql
server performance question.
Fabuloussites wrote:
> I'm considering deploying an application that will us an IP address locait
on
> database provided by Ip2location.com...
> http://www.ip2location.net/ip2locat...-component.aspx
> their .net component reads data from a binary file. I'm guess i'm wonderi
ng
> which of the two options would be best.
> 1) read data from the binary files (~27 mb or so)
> 2) or query a sql DB with the same info.
> The database will have about 8 columns and ~ 1.8 millions rows.
> i'm developing for a high traffic webisite, and i would like to query this
> DB to get the City info from the DB when a visitor first visits the site
> (based on their ip address).
> Also, how do serialized binary files handle simultaneous file access? Wou
ld
> a high traffic webisite be able to use a serialized file efficiently if th
e
> file was read often?
> Thanks!

serializing a class & performance -- advice?

We are thinking of serializing an object & passing it toseveral functions on
web service.
This will happen about 35 times as the page loads. The class has about 20
attributes.

We're not sure on the impact serializing something has on an asp.net page
rendering, compared to say, hitting the db or something like that.
THanks

Jason ShohetJason,

I've found .Net to be very efficient. I have some routines that do a lot
more than what you're talking about and everything is running perfectly.

Of course, it all depends on the hardware also. We are running a web farm
and each box has dual itanium processors and a gig of memory so the best
advice I can give you is test it out and see.

Do you know about the "Microsoft Application Center Test" program that .Net
comes with. It's a great application that lets you hit the web server with
any number of user requests you want in order to test responsiveness.

You'll find it at: Start - All Programs - Microsoft Visual Studio.Net 2003
(or 2002 has it also) - Visual Studio.Net Enterprise Features - Microsoft
Application Center Test

Good luck testing!

--
S. Justin Gengo, MCP
Web Developer

Free code library at:
www.aboutfortunate.com

"Out of chaos comes order."
Nietzche
" Jason Shohet" <ash477@.hotmail.com> wrote in message
news:ek08q6dVDHA.1912@.TK2MSFTNGP11.phx.gbl...
> We are thinking of serializing an object & passing it toseveral functions
on
> web service.
> This will happen about 35 times as the page loads. The class has about
20
> attributes.
> We're not sure on the impact serializing something has on an asp.net page
> rendering, compared to say, hitting the db or something like that.
> THanks
> Jason Shohet
Thank you Justin. We're going to serialize... it just makes maintenance
much easier to maintain, passing around an object instead of dozens of
parameters flying all over the place :)
Even though the object will be passed a few dozen times from the
codebehind page to various webservice functions, we're going to try it.

The 'Application Center Test', I tried that, but it told me that perhaps
there weren't sufficient permissions on the server. Any idea what is req'd.
If not i'll ask on the ng for that product.

Thanks
Jason Shohet
Sorry, but I haven't run into a permissions problem myself, but our
development server (a mimic of production but behind our firewall) is pretty
open.

Sincerely,

--
S. Justin Gengo, MCP
Web Developer

Free code library at:
www.aboutfortunate.com

"Out of chaos comes order."
Nietzche
" Jason Shohet" <ash477@.hotmail.com> wrote in message
news:eoKuOdeVDHA.2268@.TK2MSFTNGP11.phx.gbl...
> Thank you Justin. We're going to serialize... it just makes maintenance
> much easier to maintain, passing around an object instead of dozens of
> parameters flying all over the place :)
> Even though the object will be passed a few dozen times from the
> codebehind page to various webservice functions, we're going to try it.
> The 'Application Center Test', I tried that, but it told me that perhaps
> there weren't sufficient permissions on the server. Any idea what is
req'd.
> If not i'll ask on the ng for that product.
> Thanks
> Jason Shohet
while serializing 35 times a page request will be ok, 35 web service calls a
page will be a real performance bottleneck. web services shoot for about
100-200 hits/sec, so your main site would max out at about 4-8 hits/sec.

-- bruce (sqlwork.com)

" Jason Shohet" <ash477@.hotmail.com> wrote in message
news:ek08q6dVDHA.1912@.TK2MSFTNGP11.phx.gbl...
> We are thinking of serializing an object & passing it toseveral functions
on
> web service.
> This will happen about 35 times as the page loads. The class has about
20
> attributes.
> We're not sure on the impact serializing something has on an asp.net page
> rendering, compared to say, hitting the db or something like that.
> THanks
> Jason Shohet

Thursday, March 22, 2012

Serious rendering performance issue with ASP.NET 2.0

I have no idea why, but since I'm trying to recreate my website using
ASP.NET 2.0 I've encountered so many performance issues that I'm about to
give up and continue using v1.1
Seriously, how can a page that is not that complicated be so long to render
locally, it's amazing.
This is the trace info:
aspx.page Begin PreInit
aspx.page End PreInit 0.0463518812157079 0.046352
aspx.page Begin Init 0.0464098005002422 0.000058
aspx.page End Init 0.0507724654507819 0.004363
aspx.page Begin InitComplete 0.0508315524093228 0.000059
aspx.page End InitComplete 0.0508603382273912 0.000029
aspx.page Begin PreLoad 0.050883245868358 0.000023
aspx.page End PreLoad 0.053195331957778 0.002312
aspx.page Begin Load 0.0532569148195081 0.000062
Level 1 0.055238133844633 0.001981
Level 2 1.24767331400479 1.192435
Level 3 4.70909003164662 3.461417
Level 4 5.42230239107791 0.713212
Level 5 5.42237001134501 0.000068
aspx.page End Load 5.42393065409648 0.001561
aspx.page Begin LoadComplete 5.42399207374923 0.000061
aspx.page End LoadComplete 5.42403435150968 0.000042
aspx.page Begin PreRender 5.42406120270423 0.000027
aspx.page End PreRender 5.57577572830349 0.151715
aspx.page Begin PreRenderComplete 5.57584063770924 0.000065
aspx.page End PreRenderComplete 5.57587055670185 0.000030
aspx.page Begin SaveState 5.62490234928049 0.049032
aspx.page End SaveState 5.63038270780948 0.005480
aspx.page Begin SaveStateComplete 5.63045540480471 0.000073
aspx.page End SaveStateComplete 5.63049471959238 0.000039
aspx.page Begin Render 5.63051852952689 0.000024
aspx.page End Render 21.8912725576705 16.260754
22 seconds to load a page showing up a profile & some comments, very small
pages, it's seriously unacceptable, and that is while running in debug on my
local machine (a p4 3 GHz very well equiped), it's even slower on the
website.
It seems every time I use a GridView or a Repeater, I have the same
partner.. I just recoded by forum interface using VS.NET 2005 and it's so
slow that I can't even use it.. loading a thread page takes up to 1 minute
while in ASP.NET 1.1 it can take up to 5 seconds.
Anybody knows why rendering is so slow? I was starting to believe it was
because of my VS.NET' but since the code is also executed on a remote
server, it can't be my VS.NET...
I'm running out of options here... serious problem as it's taking up all the
resources of my Windows 2003 Server.
Thank you.
P/S: Level 1 to 5 is the queries to the database and databinding, which
isn't even why it's slow.Spotnick,
Sorry your new page is running slow. Easier than porting try to use your
1.1 dll and just reference it on your 2.0 web application untill the
overseers can fix the performance issues.
Good Luck
DWS
"Spotnick" wrote:

> I have no idea why, but since I'm trying to recreate my website using
> ASP.NET 2.0 I've encountered so many performance issues that I'm about to
> give up and continue using v1.1
> Seriously, how can a page that is not that complicated be so long to rende
r
> locally, it's amazing.
> This is the trace info:
> aspx.page Begin PreInit
> aspx.page End PreInit 0.0463518812157079 0.046352
> aspx.page Begin Init 0.0464098005002422 0.000058
> aspx.page End Init 0.0507724654507819 0.004363
> aspx.page Begin InitComplete 0.0508315524093228 0.000059
> aspx.page End InitComplete 0.0508603382273912 0.000029
> aspx.page Begin PreLoad 0.050883245868358 0.000023
> aspx.page End PreLoad 0.053195331957778 0.002312
> aspx.page Begin Load 0.0532569148195081 0.000062
> Level 1 0.055238133844633 0.001981
> Level 2 1.24767331400479 1.192435
> Level 3 4.70909003164662 3.461417
> Level 4 5.42230239107791 0.713212
> Level 5 5.42237001134501 0.000068
> aspx.page End Load 5.42393065409648 0.001561
> aspx.page Begin LoadComplete 5.42399207374923 0.000061
> aspx.page End LoadComplete 5.42403435150968 0.000042
> aspx.page Begin PreRender 5.42406120270423 0.000027
> aspx.page End PreRender 5.57577572830349 0.151715
> aspx.page Begin PreRenderComplete 5.57584063770924 0.000065
> aspx.page End PreRenderComplete 5.57587055670185 0.000030
> aspx.page Begin SaveState 5.62490234928049 0.049032
> aspx.page End SaveState 5.63038270780948 0.005480
> aspx.page Begin SaveStateComplete 5.63045540480471 0.000073
> aspx.page End SaveStateComplete 5.63049471959238 0.000039
> aspx.page Begin Render 5.63051852952689 0.000024
> aspx.page End Render 21.8912725576705 16.260754
>
> 22 seconds to load a page showing up a profile & some comments, very small
> pages, it's seriously unacceptable, and that is while running in debug on
my
> local machine (a p4 3 GHz very well equiped), it's even slower on the
> website.
> It seems every time I use a GridView or a Repeater, I have the same
> partner.. I just recoded by forum interface using VS.NET 2005 and it's so
> slow that I can't even use it.. loading a thread page takes up to 1 minute
> while in ASP.NET 1.1 it can take up to 5 seconds.
> Anybody knows why rendering is so slow? I was starting to believe it was
> because of my VS.NET' but since the code is also executed on a remote
> server, it can't be my VS.NET...
> I'm running out of options here... serious problem as it's taking up all t
he
> resources of my Windows 2003 Server.
> Thank you.
> P/S: Level 1 to 5 is the queries to the database and databinding, which
> isn't even why it's slow.
>
>
I wasn't aware you could actually reference v1.1 DLL into an ASP.NET 2.0
application... good thing to know, it might help since I'm running the 2.0
Application as a subdomain of the 1.1 application right now.
Seems to affect only the rendering of databind controls such as the gridview
and the repeater.. some pages simply time out because there is a repeater
with hum, 20 data items in it?
Something that makes me think about going back, but I like the developping
tools and new controls + master pages too much of a benefit to keep on v1.1
I'll try to use the old DLL to make the site fully 2.0 to see if it will
have an impact.. but I see my web server and sql server maxing at 100% too
often these days for a single application.. but all tracing shows it's not
data related but due to rendering.. when I execute my stored procedures, the
y
run fast.
And I use Enterprise Library latest version, binding the controls with
datatables from strongly-typed datasets.
"DWS" wrote:
> Spotnick,
> Sorry your new page is running slow. Easier than porting try to use your
> 1.1 dll and just reference it on your 2.0 web application untill the
> overseers can fix the performance issues.
> Good Luck
> DWS
>
> "Spotnick" wrote:
>

Serious rendering performance issue with ASP.NET 2.0

I have no idea why, but since I'm trying to recreate my website using
ASP.NET 2.0 I've encountered so many performance issues that I'm about to
give up and continue using v1.1

Seriously, how can a page that is not that complicated be so long to render
locally, it's amazing.

This is the trace info:

aspx.page Begin PreInit
aspx.page End PreInit 0.0463518812157079 0.046352
aspx.page Begin Init 0.0464098005002422 0.000058
aspx.page End Init 0.0507724654507819 0.004363
aspx.page Begin InitComplete 0.0508315524093228 0.000059
aspx.page End InitComplete 0.0508603382273912 0.000029
aspx.page Begin PreLoad 0.050883245868358 0.000023
aspx.page End PreLoad 0.053195331957778 0.002312
aspx.page Begin Load 0.0532569148195081 0.000062
Level 1 0.055238133844633 0.001981
Level 2 1.24767331400479 1.192435
Level 3 4.70909003164662 3.461417
Level 4 5.42230239107791 0.713212
Level 5 5.42237001134501 0.000068
aspx.page End Load 5.42393065409648 0.001561
aspx.page Begin LoadComplete 5.42399207374923 0.000061
aspx.page End LoadComplete 5.42403435150968 0.000042
aspx.page Begin PreRender 5.42406120270423 0.000027
aspx.page End PreRender 5.57577572830349 0.151715
aspx.page Begin PreRenderComplete 5.57584063770924 0.000065
aspx.page End PreRenderComplete 5.57587055670185 0.000030
aspx.page Begin SaveState 5.62490234928049 0.049032
aspx.page End SaveState 5.63038270780948 0.005480
aspx.page Begin SaveStateComplete 5.63045540480471 0.000073
aspx.page End SaveStateComplete 5.63049471959238 0.000039
aspx.page Begin Render 5.63051852952689 0.000024
aspx.page End Render 21.8912725576705 16.260754

22 seconds to load a page showing up a profile & some comments, very small
pages, it's seriously unacceptable, and that is while running in debug on my
local machine (a p4 3 GHz very well equiped), it's even slower on the
website.

It seems every time I use a GridView or a Repeater, I have the same
partner.. I just recoded by forum interface using VS.NET 2005 and it's so
slow that I can't even use it.. loading a thread page takes up to 1 minute
while in ASP.NET 1.1 it can take up to 5 seconds.

Anybody knows why rendering is so slow? I was starting to believe it was
because of my VS.NET' but since the code is also executed on a remote
server, it can't be my VS.NET...

I'm running out of options here... serious problem as it's taking up all the
resources of my Windows 2003 Server.

Thank you.

P/S: Level 1 to 5 is the queries to the database and databinding, which
isn't even why it's slow.Spotnick,
Sorry your new page is running slow. Easier than porting try to use your
1.1 dll and just reference it on your 2.0 web application untill the
overseers can fix the performance issues.

Good Luck
DWS

"Spotnick" wrote:

> I have no idea why, but since I'm trying to recreate my website using
> ASP.NET 2.0 I've encountered so many performance issues that I'm about to
> give up and continue using v1.1
> Seriously, how can a page that is not that complicated be so long to render
> locally, it's amazing.
> This is the trace info:
> aspx.page Begin PreInit
> aspx.page End PreInit 0.0463518812157079 0.046352
> aspx.page Begin Init 0.0464098005002422 0.000058
> aspx.page End Init 0.0507724654507819 0.004363
> aspx.page Begin InitComplete 0.0508315524093228 0.000059
> aspx.page End InitComplete 0.0508603382273912 0.000029
> aspx.page Begin PreLoad 0.050883245868358 0.000023
> aspx.page End PreLoad 0.053195331957778 0.002312
> aspx.page Begin Load 0.0532569148195081 0.000062
> Level 1 0.055238133844633 0.001981
> Level 2 1.24767331400479 1.192435
> Level 3 4.70909003164662 3.461417
> Level 4 5.42230239107791 0.713212
> Level 5 5.42237001134501 0.000068
> aspx.page End Load 5.42393065409648 0.001561
> aspx.page Begin LoadComplete 5.42399207374923 0.000061
> aspx.page End LoadComplete 5.42403435150968 0.000042
> aspx.page Begin PreRender 5.42406120270423 0.000027
> aspx.page End PreRender 5.57577572830349 0.151715
> aspx.page Begin PreRenderComplete 5.57584063770924 0.000065
> aspx.page End PreRenderComplete 5.57587055670185 0.000030
> aspx.page Begin SaveState 5.62490234928049 0.049032
> aspx.page End SaveState 5.63038270780948 0.005480
> aspx.page Begin SaveStateComplete 5.63045540480471 0.000073
> aspx.page End SaveStateComplete 5.63049471959238 0.000039
> aspx.page Begin Render 5.63051852952689 0.000024
> aspx.page End Render 21.8912725576705 16.260754
>
> 22 seconds to load a page showing up a profile & some comments, very small
> pages, it's seriously unacceptable, and that is while running in debug on my
> local machine (a p4 3 GHz very well equiped), it's even slower on the
> website.
> It seems every time I use a GridView or a Repeater, I have the same
> partner.. I just recoded by forum interface using VS.NET 2005 and it's so
> slow that I can't even use it.. loading a thread page takes up to 1 minute
> while in ASP.NET 1.1 it can take up to 5 seconds.
> Anybody knows why rendering is so slow? I was starting to believe it was
> because of my VS.NET' but since the code is also executed on a remote
> server, it can't be my VS.NET...
> I'm running out of options here... serious problem as it's taking up all the
> resources of my Windows 2003 Server.
> Thank you.
> P/S: Level 1 to 5 is the queries to the database and databinding, which
> isn't even why it's slow.
>
I wasn't aware you could actually reference v1.1 DLL into an ASP.NET 2.0
application... good thing to know, it might help since I'm running the 2.0
Application as a subdomain of the 1.1 application right now.

Seems to affect only the rendering of databind controls such as the gridview
and the repeater.. some pages simply time out because there is a repeater
with hum, 20 data items in it?

Something that makes me think about going back, but I like the developping
tools and new controls + master pages too much of a benefit to keep on v1.1

I'll try to use the old DLL to make the site fully 2.0 to see if it will
have an impact.. but I see my web server and sql server maxing at 100% too
often these days for a single application.. but all tracing shows it's not
data related but due to rendering.. when I execute my stored procedures, they
run fast.

And I use Enterprise Library latest version, binding the controls with
datatables from strongly-typed datasets.

"DWS" wrote:

> Spotnick,
> Sorry your new page is running slow. Easier than porting try to use your
> 1.1 dll and just reference it on your 2.0 web application untill the
> overseers can fix the performance issues.
> Good Luck
> DWS
>
> "Spotnick" wrote:
> > I have no idea why, but since I'm trying to recreate my website using
> > ASP.NET 2.0 I've encountered so many performance issues that I'm about to
> > give up and continue using v1.1
> > Seriously, how can a page that is not that complicated be so long to render
> > locally, it's amazing.
> > This is the trace info:
> > aspx.page Begin PreInit
> > aspx.page End PreInit 0.0463518812157079 0.046352
> > aspx.page Begin Init 0.0464098005002422 0.000058
> > aspx.page End Init 0.0507724654507819 0.004363
> > aspx.page Begin InitComplete 0.0508315524093228 0.000059
> > aspx.page End InitComplete 0.0508603382273912 0.000029
> > aspx.page Begin PreLoad 0.050883245868358 0.000023
> > aspx.page End PreLoad 0.053195331957778 0.002312
> > aspx.page Begin Load 0.0532569148195081 0.000062
> > Level 1 0.055238133844633 0.001981
> > Level 2 1.24767331400479 1.192435
> > Level 3 4.70909003164662 3.461417
> > Level 4 5.42230239107791 0.713212
> > Level 5 5.42237001134501 0.000068
> > aspx.page End Load 5.42393065409648 0.001561
> > aspx.page Begin LoadComplete 5.42399207374923 0.000061
> > aspx.page End LoadComplete 5.42403435150968 0.000042
> > aspx.page Begin PreRender 5.42406120270423 0.000027
> > aspx.page End PreRender 5.57577572830349 0.151715
> > aspx.page Begin PreRenderComplete 5.57584063770924 0.000065
> > aspx.page End PreRenderComplete 5.57587055670185 0.000030
> > aspx.page Begin SaveState 5.62490234928049 0.049032
> > aspx.page End SaveState 5.63038270780948 0.005480
> > aspx.page Begin SaveStateComplete 5.63045540480471 0.000073
> > aspx.page End SaveStateComplete 5.63049471959238 0.000039
> > aspx.page Begin Render 5.63051852952689 0.000024
> > aspx.page End Render 21.8912725576705 16.260754
> > 22 seconds to load a page showing up a profile & some comments, very small
> > pages, it's seriously unacceptable, and that is while running in debug on my
> > local machine (a p4 3 GHz very well equiped), it's even slower on the
> > website.
> > It seems every time I use a GridView or a Repeater, I have the same
> > partner.. I just recoded by forum interface using VS.NET 2005 and it's so
> > slow that I can't even use it.. loading a thread page takes up to 1 minute
> > while in ASP.NET 1.1 it can take up to 5 seconds.
> > Anybody knows why rendering is so slow? I was starting to believe it was
> > because of my VS.NET' but since the code is also executed on a remote
> > server, it can't be my VS.NET...
> > I'm running out of options here... serious problem as it's taking up all the
> > resources of my Windows 2003 Server.
> > Thank you.
> > P/S: Level 1 to 5 is the queries to the database and databinding, which
> > isn't even why it's slow.