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