Hello Zeitgeist Framework Team,
Friends of GNOME Zeitgeist has a new message requiring your approval.
Subject: RE: 17.9.2010 V|AGRA \xae Official 82% 0FF!
Author name: Friends of GNOME Zeitgeist
Author url: https://launchpad.net/~gnome-zeitgeist-users
Date: 2010-09-18 01:04:16+00:
Public bug reported:
Right now when I am running zeitgeist-daemon and I insert an event, I
get an output
DEBUG:zeitgeist.engine:Inserted 1 events in 0.004629s
Can be event_id be also a part of it? It can be very much useful in
debugging scenarios
Proposed:
DEBUG:zeitgeist.engine:Inserted 1 eve
** Branch linked: lp:~thekorn/zeitgeist/fix-641198-glob-use-index
--
Prefix search is not using an index
https://bugs.launchpad.net/bugs/641198
You received this bug notification because you are a member of Zeitgeist
Framework Team, which is subscribed to Zeitgeist Framework.
Status in Zeitgeist
The proposal to merge lp:~zeitgeist/zeitgeist/pragma-settings into lp:zeitgeist
has been updated.
Description changed to:
Turned the lock settings to EXCLUSIVE (no harm done there):
---
When the locking-mode is set t
** Changed in: zeitgeist
Status: New => Confirmed
--
Slow queries: SQL indexes not used
https://bugs.launchpad.net/bugs/632363
You received this bug notification because you are a member of Zeitgeist
Framework Team, which is subscribed to Zeitgeist Framework.
Status in Zeitgeist Framework
** Changed in: zeitgeist
Status: New => Confirmed
** Changed in: zeitgeist
Milestone: None => 0.5.2
--
Bad documentation of zeitgeist.datamodel.Symbol
https://bugs.launchpad.net/bugs/640277
You received this bug notification because you are a member of Zeitgeist
Framework Team, which
Hello Zeitgeist Framework Team,
On 2010-09-17 14:18z (12 minutes ago), you uploaded a translation
template for zeitgeist in Zeitgeist Framework 0.3 in Launchpad.
The template has now been imported successfully.
Thank you,
The Launchpad team
___
Mail
Hello Zeitgeist Framework Team,
On 2010-09-17 14:18z (10 minutes ago), you uploaded a translation
template for zeitgeist in Zeitgeist Framework 0.1 in Launchpad.
The template has now been imported successfully.
Thank you,
The Launchpad team
___
Mail
** Branch linked: lp:~zeitgeist/zeitgeist/pragma-settings
--
Improve insertion times
https://bugs.launchpad.net/bugs/639737
You received this bug notification because you are a member of Zeitgeist
Framework Team, which is subscribed to Zeitgeist Framework.
Status in Zeitgeist Framework: Triaged
Seif Lotfy has proposed merging lp:~zeitgeist/zeitgeist/pragma-settings into
lp:zeitgeist.
Requested reviews:
Zeitgeist Framework Team (zeitgeist)
Related bugs:
#639737 Improve insertion times
https://bugs.launchpad.net/bugs/639737
Basically I turned the lock settings to EXCLUSIVE (no har
yes it is confirmed and architecture 64 bit here too.
- Original message -
> Thank you for your bug report.
>
> Can you please confirm whether this is the same error as here:
> https://bugs.launchpad.net/gnome-activity-journal/+bug/641148
>
> ** Changed in: gnome-activity-journal
>
** Branch linked: lp:zeitgeist
--
ZeitgeistEngine.__init__(): statement to get last row id is not using the index
https://bugs.launchpad.net/bugs/641100
You received this bug notification because you are a member of Zeitgeist
Framework Team, which is subscribed to Zeitgeist Framework.
Status in
** Changed in: zeitgeist
Status: In Progress => Fix Committed
--
ZeitgeistEngine.__init__(): statement to get last row id is not using the index
https://bugs.launchpad.net/bugs/641100
You received this bug notification because you are a member of Zeitgeist
Framework Team, which is subscrib
The proposal to merge lp:~thekorn/zeitgeist/fix-641100-min-max-use-index into
lp:zeitgeist has been updated.
Status: Needs review => Merged
--
https://code.launchpad.net/~thekorn/zeitgeist/fix-641100-min-max-use-index/+merge/35786
Your team Zeitgeist Framework Team is requested to review the
Mikkel, thanks for doing the review,
yes, the case of an empty db is covered by our unittests and everything works
just fine.
(
MIN/MAX always return sth. even if the table it's operating on is empty
In [7]: con = sqlite3.connect(":memory:")
In [8]: con.execute("CREATE TABLE boo(x)")
Out[8]:
BTW the tests were done on empty DBs
I wonder how they affect the query times
--
Improve insertion times
https://bugs.launchpad.net/bugs/639737
You received this bug notification because you are a member of Zeitgeist
Framework Team, which is subscribed to Zeitgeist Framework.
Status in Zeitgeist
Here a more detailed benchmarking:
1) NO CHANGES: ~ 0.12 s
DEBUG:zeitgeist.engine:Inserted 1 events in 0.107999s
DEBUG:zeitgeist.engine:Inserted 1 events in 0.155844s
DEBUG:zeitgeist.engine:Inserted 1 events in 0.128242s
DEBUG:zeitgeist.engine:Inserted 1 events in 0.161610
Thank you for your bug report.
Can you please confirm whether this is the same error as here:
https://bugs.launchpad.net/gnome-activity-journal/+bug/641148
** Changed in: gnome-activity-journal
Status: New => Incomplete
--
AttributeError: 'Symbol' object has no attribute 'COMMENT'
https
** Changed in: gnome-activity-journal
Milestone: None => 0.5.1
--
The Hamster code uses Interpretation.COMMENT
https://bugs.launchpad.net/bugs/641148
You received this bug notification because you are a member of GNOME
Zeitgeist Team, which is the registrant for GNOME Activity Journal.
Statu
review approve
Looks good, i'm just wondering how it fares with an empty db? But I
guess the unit tests will catch this if it's an issue.
--
https://code.launchpad.net/~thekorn/zeitgeist/fix-641100-min-max-use-index/+merge/35786
Your team Zeitgeist Framework Team is requested to review the propos
** Changed in: zeitgeist (Ubuntu)
Status: New => Fix Released
--
zeitgeist-daemon crashed with OverflowError in call_async()
https://bugs.launchpad.net/bugs/559350
You received this bug notification because you are a member of Zeitgeist
Framework Team, which is subscribed to Zeitgeist Fram
** Attachment added: "glob-index-test.py"
https://bugs.edge.launchpad.net/bugs/641198/+attachment/1597664/+files/glob-index-test.py
** Changed in: zeitgeist
Status: New => In Progress
** Changed in: zeitgeist
Assignee: (unassigned) => Markus Korn (thekorn)
--
Prefix search is n
Public bug reported:
In the prefix search we are using a 'GLOB' sql-statement, this statement
is not using the index and thus slow, some timings from me running the
attached script:
* Database with ~50k events
* ~1% of these event have a subject with uri beginning with 'http://aa'
* searching fo
** Changed in: zeitgeist
Assignee: (unassigned) => Markus Korn (thekorn)
** Changed in: zeitgeist
Status: New => In Progress
--
ZeitgeistEngine.__init__(): statement to get last row id is not using the index
https://bugs.launchpad.net/bugs/641100
You received this bug notification be
WHOA +1
On Fri, Sep 17, 2010 at 10:40 AM, Siegfried Gevatter
wrote:
> 1. +1
> 2. SQLITE sucks. Big time.
>
> --
> ZeitgeistEngine.__init__(): statement to get last row id is not using the
> index
> https://bugs.launchpad.net/bugs/641100
> You received this bug notification because you are subscri
1. +1
2. SQLITE sucks. Big time.
--
ZeitgeistEngine.__init__(): statement to get last row id is not using the index
https://bugs.launchpad.net/bugs/641100
You received this bug notification because you are a member of Zeitgeist
Framework Team, which is subscribed to Zeitgeist Framework.
Status i
** Branch linked: lp:~thekorn/zeitgeist/fix-641100-min-max-use-index
--
ZeitgeistEngine.__init__(): statement to get last row id is not using the index
https://bugs.launchpad.net/bugs/641100
You received this bug notification because you are a member of Zeitgeist
Framework Team, which is subscrib
Markus Korn has proposed merging
lp:~thekorn/zeitgeist/fix-641100-min-max-use-index into lp:zeitgeist.
Requested reviews:
Zeitgeist Framework Team (zeitgeist)
Related bugs:
#641100 ZeitgeistEngine.__init__(): statement to get last row id is not using
the index
https://bugs.launchpad.net/bu
Damn dude, how can sqlite not use the index for the original query..?
Just goes to show that it's definitely worth it to scrutinize those
query plans!
Totally +1
--
ZeitgeistEngine.__init__(): statement to get last row id is not using the index
https://bugs.launchpad.net/bugs/641100
You received
** Attachment added: "min-max-test.py"
https://bugs.edge.launchpad.net/bugs/641100/+attachment/1597228/+files/min-max-test.py
--
ZeitgeistEngine.__init__(): statement to get last row id is not using the index
https://bugs.launchpad.net/bugs/641100
You received this bug notification because y
Public bug reported:
The attached script is creating a log with ~49k events.
In the constructor of ZeitgeistEngine we need to search for the minimum and
maximum event id. In the script I'm doing two different ways of getting these
values:
Our current query:
SELECT MIN(id), MAX(id) FROM event
-
Hello Zeitgeist Framework Team,
On 2010-09-17 07:49z (8 minutes ago), you uploaded a translation
template for zeitgeist in Zeitgeist Framework 0.3 in Launchpad.
The template has now been imported successfully.
Thank you,
The Launchpad team
___
Maili
Hello Zeitgeist Framework Team,
On 2010-09-17 07:49z (8 minutes ago), you uploaded a translation
template for zeitgeist in Zeitgeist Framework 0.1 in Launchpad.
The template has now been imported successfully.
Thank you,
The Launchpad team
___
Maili
33 matches
Mail list logo
