Hi,

 

Just replace line

ArrayList countryList = new ArrayList(Esperantus.CountryInfo.GetCountries(Esperantus.CountryTypes.AllCountries,Esperantus.CountryFields.DisplayName));

 

by

 

ArrayList countryList = new ArrayList();

In Configuration/settings/partalsettings.cs (line 877)

 

You will loose the possibility to filter countries, but you will increase of more than 50% your performances on startup.

 

Regards,

 

marcb@hotmail.com

 

 

-----Message d'origine-----
De : rainbowportal-devel-admin@lists.sourceforge.net [mailto:rainbowportal-devel-admin@lists.sourceforge.net] De la part de AUDENAERT Geert
Envoyé : jeudi 19 février 2004 08:12
À : Cory Isakson; rainbowportal-devel@lists.sourceforge.net
Objet : RE: [Rainbowportal-devel] cpu times used on startup?

 

This doesn't explain the havy cpu usage done by the sql server. When we were doiing rainbow last year, i did some research on this. I found out that far too many database request were done to fullfill one http call.

 

We solved this by retaining all the structure data (data concerning portals, pages, modules) in the cache and only update this cache when something in structure changed. This way only the real data on the pages war retrieved from the database, which lessened the number of database requests with 85%. We gained an emormous amaount of performance, and with the same server configurations, we could handle 50x times more requests.

 

Greetings,

 

Geert

 

-----Original Message-----

From: rainbowportal-devel-admin@lists.sourceforge.net

[mailto:rainbowportal-devel-admin@lists.sourceforge.net]On Behalf Of

Cory Isakson

Sent: dinsdag 17 februari 2004 16:32

To: rainbowportal-devel@lists.sourceforge.net

Subject: Re: [Rainbowportal-devel] cpu times used on startup?

 

 

Chris,

 

The Webcompile only runs on first hit, but it runs in a separate thread.

The application is not JIT compiled in any way until it is executed once.

IBUYSPY is much smaller than Rainbow so it makes sense that it compiles

faster.  There may be additional things going on as well.  I will make a

note to work on improving that in the next version.

 

Cory Isakson

http://blog.coryisakson.com/

 

----- Original Message -----

From: "Chris Farrell" <chris@cftechconsulting.com>

To: <rainbowportal-devel@lists.sourceforge.net>

Sent: Monday, February 16, 2004 9:55 PM

Subject: [Rainbowportal-devel] cpu times used on startup?

 

 

> Gang

>    I was trying to be helpful in the forums but really this is a topic

> I'm

> not that involved in.

> I do see this comment often and in some recent testing I am a bit

> curious

> as well.

> forums post

> http://www.rainbowportal.net/AspNetForums/ShowPost.aspx?PostID=6244

> A very common and valid question.  Why the first page takes so long to

> load.  Why isn't

> webcompile keeping it alive?

> 2:  Just testing on my system, a 1.2ghz AMD running Windows XP and an

> evaluation version

> of SQL Server 2000.

> aspnet_wp.exe 13 seconds cpu time.

> sqlserver.exe 11 seconds cpu time.

> Why on earth would sql server need 11 seconds cpu time?  Can there

> really

> be that many

> queries in startup to justify 11 seconds cpu time?  I have done some

> database projects that

> involved far more data, horribly complex many table joins, etc on

> access 2k

> and it didn't

> use 3 seconds of cpu time.

> Using issreset.exe I purged the aspnet_wp.exe process and any

> cache.  Reloaded the

> Rainbow portal and also the IBuySpy portal.  Consistently rainbow took

> 9-11

> seconds cpu

> time in sql server, IBuySpy portal used less than a second in the

> sqlserver.exe process.

> Is something wrong here?

> Chris Farrell

> chris@cftechconsulting.com

> http://www.cftechconsulting.com

> -------------------------------------------------------

> SF.Net is sponsored by: Speed Start Your Linux Apps Now.

> Build and deploy apps & Web services for Linux with

> a free DVD software kit from IBM. Click Now!

> http://ads.osdn.com/?ad_id=1356&alloc_id=3438&op=click

> _______________________________________________

> Rainbowportal-devel mailing list

> Rainbowportal-devel@lists.sourceforge.net

> https://lists.sourceforge.net/lists/listinfo/rainbowportal-devel

 

 

 

-------------------------------------------------------

SF.Net is sponsored by: Speed Start Your Linux Apps Now.

Build and deploy apps & Web services for Linux with

a free DVD software kit from IBM. Click Now!

http://ads.osdn.com/?ad_id=1356&alloc_id=3438&op=click

_______________________________________________

Rainbowportal-devel mailing list

Rainbowportal-devel@lists.sourceforge.net

https://lists.sourceforge.net/lists/listinfo/rainbowportal-devel

 

 

STRICTLY PERSONAL AND CONFIDENTIAL

This message may contain confidential and proprietary material for the sole use of the intended recipient. Any review or distribution by others is strictly prohibited. If you are not the intended recipient please contact the sender and delete all copies.

 

Ce Message est uniquement destiné aux destinataires indiqués et peut contenir des informations confidentielles. Si vous n'êtes pas le destinataire, vous ne devez pas révéler le contenu de ce message ou en prendre copie. Si vous avez reçu ce message par erreur, veuillez en informer l'expéditeur, ou La Poste immédiatement, avant de le supprimer.

 

Dit bericht is enkel bestemd voor de aangeduide ontvangers en kan vertrouwelijke informatie bevatten. Als u niet de ontvanger bent, dan mag u de inhoud van dit bericht niet bekendmaken noch kopiëren. Als u dit bericht per vergissing heeft ontvangen, gelieve er de afzender of De Post onmiddellijk van op de hoogte te brengen en het bericht vervolgens te verwijderen.

H¶¦¢oyµb.Ä°uu£¦n¾±.Ç…y
·z~ –6¶ý¢ri


é¡