Performance Data on a slow machine for Engineering

Hi Logos, you guys are great and L4 is a wonderful upgrade!

I really hate to pass this on, because as a software engineer it's annoying to get details from customers, so please take this in the helpful vein it is offered.

I'm still wondering why performance in L4 is inconsistent on my system. So I collected events with MS's Performance Monitor and analyzed them.

Just looking at disk hits to perform an operation once, I found the following:

1,085 - to display the Layout menu (Most were SQLite queries on layouts.db - no surprise there)
4,015 - to display a layout with only a bible
126 - to display the home page

There were three things noteworthy:

Of the 4,015 disk hits 321 involved PreferencesManager.db.
It ran QueryOpen/CreateFile on PreferencesManager.db-journal and the system returned "FAST IO DISALLOWED" and "NAME NOT FOUND" 165 times.
It also ran "QuerySizeInformationVolume" on C:\Users\dad\Desktop 40 times to change layout once

None of those might be an issue - I wouldn't know. But if some people have disk systems that allow "FAST IO" and others, such as mine, do not, it might be a common factor to look at.

Also, SQLite is doing the QuerySizeInformationVolume. Maybe there's a way to tell SQLite to knock it off.

Again, I'm trying not to be a pest or flood you with useless information.

Steve

Find more posts tagged with

Comments

Steve Sando

FWIW: on my system it take15 seconds to type "vitiating" in the Miriam Webster Dictionary window. There are >110,000 hits on this file, per keystroke:

C:\Users\dad\AppData\Local\Logos4\Data\s3xxxm2q.2ct\ResourceManager\logos\LLS_46_10_22_2009_10_27T22_03_02Z.mstidx

Steve

Steven Kaminski

https://community.logos.com/discussion/comment/35422#Comment_35422

Excellent analysis, Steve. I look forward to the response.

Dave Hooton

https://community.logos.com/discussion/comment/35422#Comment_35422

Good data, Steve. I'm sure Logos will be interested (if they don't already know) because optimising the system is one of their goals. As an example Bradley quoted, just producing a list of Hebrew words to match an input went from 50s to 250 ms.

sdfsdfsdfdf

https://community.logos.com/discussion/comment/35452#Comment_35452

I suppose I should come clean. I've been building commercial software products using SQL databases for about 20 years. Most recently I managed an engeering team for a consummer electronics product. It was an embedded system using SQLite. Performance was critical. The more CPU it required the higher our BOM cost, that meant the greater the retail price, and the less competitive we were.

So, software performance and SQL databases have been a central part of my career.

Steve