| Time |
S |
Nick |
Message |
| 11:04 |
|
kados |
hi all |
| 11:04 |
|
kados |
paul: I'm taking a look at searching queries today and I'm wondering what's the difference between these: |
| 11:05 |
|
kados |
select distinct m1.bibid from marc_word as m1,marc_word as m2 where (m1.bibid=m2.bibid)and ((m1.word like 'block') and (m2.word like 'john')); |
| 11:06 |
|
kados |
select distinct m1.bibid from biblio,biblioitems,marc_biblio,marc_word as m1,marc_word as m2 where biblio.biblionumber=marc_biblio.biblionumber and biblio.biblionumber=biblioitems.biblionumber and m1.bibid=marc_biblio.bibid and (m1.bibid=m2.bibid) and ((m1.word like 'block')and (m2.word like 'john')) |
| 11:06 |
|
kados |
(in my tests, with NPL data they seem to be the same ... am I missing something?) |
| 11:07 |
|
paul |
you're right, they are the same. Except when you add "order by biblioitems.isbn" for example |
| 11:07 |
|
paul |
('morning kados) |
| 11:07 |
|
kados |
(evening paul ;-)) |
| 11:08 |
|
kados |
ahh ... I see ... but I think the orderby is destroyed anyway |
| 11:08 |
|
paul |
destroyed by who ? |
| 11:08 |
|
paul |
NPL specific hack ? |
| 11:09 |
|
kados |
I thought it was destroyed when the object was hashed |
| 11:11 |
|
kados |
I think I'm wrong |
| 11:11 |
|
kados |
so I had a real nice sort process that really messes up perfs for searches with result sets |
| 11:12 |
|
kados |
it uses marc non-filing chars |
| 11:12 |
|
kados |
I'm thinking of adding a colum to marc_word for biblio.title |
| 11:12 |
|
kados |
(without the non-filing chars) |
| 11:12 |
|
kados |
strictly for sorting purposes |
| 11:13 |
|
kados |
so I can sort properly for English results (i.e., don't order by the articles a and the, etc.) |
| 11:13 |
|
kados |
does that sound like the best solution? |
| 11:14 |
|
kados |
it's too bad we can't make marc_word automatically sorted correctly |
| 11:15 |
|
kados |
that would maybe be another way to do it |
| 11:27 |
|
paul |
kados... |
| 11:27 |
|
paul |
the marc_word is huge enough not to have another column ! |
| 11:28 |
|
paul |
i will add in the future (2 months ? 3 ?) a hack to order correctly the titles. |
| 11:28 |
|
paul |
it will require a new column in biblio (let imagine biblio.Stitle, S being for "simplified") |
| 11:29 |
|
paul |
the Stitle being filled with articles removed at the beginning of the field. |
| 11:29 |
|
paul |
Also note that we should not expect too many perf improvements until we have marc_words. |
| 11:30 |
|
paul |
I made some tests on my biggest DB (45000 biblios, 2 950 000 lines in marc_word) |
| 11:30 |
|
paul |
with the marc_words, you have just 450 000 lines. |
| 11:30 |
|
paul |
You can test yourself the effect for NPL with the following query : |
| 11:31 |
|
paul |
select count(*), subfieldvalue,tag,subfieldcode from marc_word group by tag,subfieldcode,subfieldvalue |
| 11:31 |
|
paul |
& count how many lines you will have. |
| 11:31 |
|
paul |
I have some othe ideas to improve them more. |
| 11:32 |
|
paul |
like "removing word indexes" option in MARC setup. To avoid indexing useless fields/subfields (like the 1xx ones in UNIMARC, or some others) |
| 11:37 |
|
paul |
oups, my query does not work : |
| 11:37 |
|
paul |
select count(*), word,tagsubfield from marc_word group by tagsubfield,word |
| 11:37 |
|
paul |
is better |
| 11:38 |
|
kados |
yea ... I've done that in the past and my result are similar |
| 11:38 |
|
kados |
it will really speed up with marc_words |
| 11:40 |
|
kados |
paul do you have the book "high performance mysql"? |
| 11:40 |
|
paul |
nope |
| 11:40 |
|
paul |
do you think I should buy it ? |
| 11:40 |
|
kados |
yes |
| 11:41 |
|
kados |
http://www.oreilly.com/catalog/hpmysql/ |
| 11:42 |
|
kados |
(unless you already know all that stuff ;-)) |
| 11:42 |
|
kados |
it specifically addresses application design |
| 11:42 |
|
kados |
citing useing mysql in environments where the tables are several _billion_ rows |
| 11:44 |
|
paul |
ok, i'm buying it now ;-) (even if it's in english only...) |
| 11:57 |
|
hdl |
paul: fais moi signe quand tu seras disponible |
| 11:58 |
|
paul |
ok, faut que je reboote, puis je te rappelle (je finis juste un mail) |
| 11:58 |
|
hdl |
ok. |
| 12:06 |
|
kados |
paul: i just sent you an email about marc non-filing chars in MARC21 |
| 12:13 |
|
kados |
paul: i just sent you an email about marc non-filing chars in MARC21 (it may be useful for your upcoming sort feature) |
| 12:13 |
|
paul |
yes, it's in my mailbox now |
| 17:07 |
|
rach |
morning |
| 17:09 |
|
kados |
hi rach |
| 17:11 |
|
rach |
how's the new site coming joshua? |
| 17:37 |
|
hdl |
hi rach |
| 18:11 |
|
kados |
rach: it's coming ;-) we've launched it at liblime.com but are waiting until the demos are done (and priv/terms) before we make an announcement |
| 18:11 |
|
kados |
we should be adding our templates to Koha soon as well |
| 19:30 |
|
rosa |
Hi anyone. is there a spanish language list for Koha? |
| 19:46 |
|
michael |
... any french here ? |
| 19:46 |
|
michael |
hi NZ and hi FRANCE ;-) |
| 19:46 |
|
michael |
and other too that i don't know country... |
| 19:46 |
|
rosa |
hi michael |
| 19:47 |
|
michael |
hi rosa |
| 20:29 |
|
michael |
... |
| 20:29 |
|
michael |
... |
| 20:30 |
|
michael |
i'm here if anyone want to tell something great (or even) stupid in French or English ;-) |
| 20:54 |
|
rach |
hi |
| 20:54 |
|
rach |
bonjour is about the extent of my french |
| 20:54 |
|
rach |
are you interested in Koha? |
| 20:58 |
|
michael |
no pb... i wish paul was not already in bed but i'll wait or speak to him another day or night... no pb |
| 21:45 |
|
michael |
hi... |
| 21:45 |
|
michael |
did anyone know how u can get invited to the IRC katipo chan ?? |
| 21:58 |
|
rach |
hi |
| 21:58 |
|
rach |
sorry what? |
| 22:13 |
|
michael |
... |
| 22:13 |
|
michael |
hi rachel ! |
| 22:13 |
|
michael |
i just subscribe to the koha list and send a msg |
| 22:14 |
|
michael |
here's the end of this message (almost in french) |
| 22:15 |
|
michael |
the english part is : |
| 22:15 |
|
michael |
"Koha coming soon in bêta-test in a french library" in the subject and here in English : |
| 22:15 |
|
michael |
################### ################### ################### |
| 22:15 |
|
michael |
Hi everyone Katipo and Koha team who doesn't read or understand french, |
| 22:15 |
|
michael |
this is for annoning that a new french library will install and test Koha |
| 22:15 |
|
michael |
this is a public library, about 170 000 items i think and 5 000 |
| 22:15 |
|
michael |
borrowers as far as i remenber |
| 22:15 |
|
michael |
is that possible te be added in the Koha map? i started all this stuff |
| 22:15 |
|
michael |
of installation, migration in the next two weeks. my name is Michaël |
| 22:15 |
|
michael |
Reichhard, i often go to chat on the IRC Channel |
| 22:15 |
|
michael |
Here's what you can put on the Koha Map in Europe |
| 22:15 |
|
michael |
http://koha.org/about/map/europe.html |
| 22:15 |
|
michael |
Organisation: Médiathèque |
| 22:15 |
|
michael |
Version: Koha 2.2.1 |
| 22:15 |
|
michael |
Library Type: Public Library |
| 22:15 |
|
michael |
Location: Meudon, France |
| 22:15 |
|
michael |
Contact: Michaël Reichhard (mreichhard gmail.com) |
| 22:15 |
|
michael |
Description: Bêta-test to show how Koha could be a solution for a |
| 22:15 |
|
michael |
future migration of our old integrated library system |
| 22:15 |
|
michael |
sorry, it's late here (00h28) and i'm not enough good to translate the |
| 22:15 |
|
michael |
complete message. but i think Paul and i will give you more |
| 22:15 |
|
michael |
explanations in the next few days and weeks. |
| 22:15 |
|
michael |
Long live to open source and koha in particular ;-) |
| 22:15 |
|
michael |
Freely, |
| 22:15 |
|
michael |
-- |
| 22:15 |
|
michael |
Michaël |
| 22:15 |
|
michael |
################### ################### ################### |
| 22:15 |
|
michael |
no joke i swear ;-) |
| 23:18 |
|
rach |
hi michael, sounds good |
| 23:18 |
|
rach |
if you're in france isn't it the middle of the night? |
| 23:19 |
|
michael |
... i hope so... i'll probably be more active in the diffrent ML |
| 23:19 |
|
michael |
yes.. it's 3h22... always... as Albert Einstein says : "I don't sleep much. But i sleep fast" |
| 23:19 |
|
rach |
:-) |
| 23:19 |
|
michael |
"Je ne dors pas longtemps. Mais je dors vite" Albert Einstein |
| 23:20 |
|
rach |
paul keeps a bit more regular hours |
| 23:20 |
|
rach |
so you wont catch him here at this time of day |
| 23:22 |
|
rach |
that sounds like good news about your public library :-) |
| 23:22 |
|
rach |
do you work for them, or are you a contractor? |
| 23:26 |
|
michael |
yes, thanx |
| 23:27 |
|
michael |
i work in THIS public library... 39h/semaine... anyone understand french in katipo.. if the case, i could send you the whole message in french.. |
| 23:28 |
|
rach |
ah no I don't think we do really I'm sorry |
| 23:31 |
|
michael |
no pb... wll go to sleep soon... do you know when Paul go to Nelsonville, Ohio... did i dreamt or read this somewhere ??? |
| 23:34 |
|
michael |
i got this when i post to the list : Your mail to 'Koha' with the subject |
| 23:34 |
|
michael |
Koha bient?t en b?ta-test dans une m?diath?que municipale du 92 / |
| 23:34 |
|
michael |
Koha coming soon in b?ta-test in a french library |
| 23:34 |
|
michael |
Is being held until the list moderator can review it for approval. |
| 23:34 |
|
michael |
The reason it is being held: |
| 23:34 |
|
michael |
Too many recipients to the message |
| 23:37 |
|
michael |
bye... see you next time;.. |
| 23:37 |
|
michael |
at another hour maybe... |
| 23:45 |
|
rach |
I think in may |
| 01:18 |
|
rach |
anyone about? where do you find sub branches/locations |
| 01:19 |
|
rach |
I thought we had those, or am I dreaming? |
| 01:49 |
|
rosa |
we have real and virtual branches |
| 10:22 |
|
sylvain |
hi all |
