IRC log for #koha, 2005-03-17

All times shown according to UTC.

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
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 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
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 (
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

| Channels | #koha index | Today | | Search | Google Search | Plain-Text | plain, newest first | summary