[Bug 223439] Item listing for folders slow

[Thomas McGuire]

https://bugs.kde.org/show_bug.cgi?id=223439





--- Comment #2 from Thomas McGuire <mcguire kde org>  2010-02-02 22:14:25 ---
The problem seems to be the part query in FetchHelper::parseStream().

This is an example debug output, with some timing info:

2010-02-02T21:57:55 Executing part query. 
SELECT PimItemTable.id, PartTable.name, PartTable.data, PartTable.version,
PartTable.external FROM PimItemTable, PartTable WHERE ( PimItemTable.id =
PartTable.pimItemId AND ( PartTable.name IN ( :0, :1 ) ) AND ( PimItemTable.id
>= :2 ) AND collectionId = :3 ) ORDER BY PimItemTable.id ASC

 ":0" QVariant(QString, "COLLECTIONID")
 ":1" QVariant(QString, "PLD:HEAD")
 ":2" QVariant(qlonglong, 1)
 ":3" QVariant(qlonglong, 18882)

2010-02-02T21:58:23 Part query done, now building response.

Executing that query in the DB console has the same slowness.
Displaying the part table in the DB browser also takes about a minute here,
with ~100k entries in there.

-- 
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.