Paolo's Notes

BA by day, sleepy coder by night...

Little improvement...

From a 37 seconds startup time in normal conditions, I went to 4 seconds in optimal/normal conditions (i.e.: database up to date) or 45 seconds if the database has to be completely regenerated with new data.

Only downside: now the application carries around the Sql Server 2000 CE runtime. I shudder at the size of the install file :)

Posted: Oct 09 2003, 11:59 PM by Pmarcucci | with 3 comment(s)
Filed under:

Comments

The Jeff said:

Ya know, sometimes you have to make a sacrifice for Performance. My PDA already has the SQL CE installed & I have a cable modem, so I don't care about the size. (It helps to have a 256MB compactflash card also)
# October 10, 2003 1:45 PM

Paolo Marcucci said:

All signs point to a SQL CE enabled version released this weekend.
# October 10, 2003 3:08 PM

Doug Thews said:

Have you taken a look at some of the known performance optimization tips for CF.NET? I wrote about them awhile back on my blog: http://www.ddconsult.com/blogs/illuminati/archives/000052.html
# October 10, 2003 7:24 PM
Leave a Comment

(required) 

(required) 

(optional)

(required)