IRC log for #koha, 2015-12-21

All times shown according to UTC.

Time S Nick Message
00:23 wizzyrea frankenkoha
00:23 wizzyrea best.
00:30 dcook Does anyone know if there are any problems running Koha on Debian Jessie?
00:30 dcook I remember there used to be, but unsure if they're been resolved..
00:54 wizzyrea we have it running on jessie in a number of instances
00:54 wizzyrea and it seems to be working fine
00:54 wizzyrea have more trouble with ubuntu, tbh.
01:03 dcook Yeah?
01:04 wizzyrea yeah, things like "task scheduler doesn't work"
01:05 dcook Ahh
01:05 dcook I think I actually just found a bug in Debian :p
01:05 dcook Well, Gnome at least..
01:06 dcook Gotta love variables like "NoDisplay=false"
01:07 dcook I guess "Display" is probably already taken... so they had to use the negative
01:08 wizzyrea I don't think I've ever used a gui on debian proper.
01:09 dcook "Main Menu" seems to create a local desktop launcher in ~/.local/share/applications which gets called ahead of /usr/share/applications/, but it doesn't seem to actually update either..
01:09 dcook Really?
01:09 wizzyrea I don't mean that as a rude thing, only as a fact. Really.
01:09 dcook I think I've been using Debian as a desktop OS since 2013?
01:09 dcook Oh, I didn't think it was a rude thing
01:09 dcook I know Ubuntu and Mint tend to be the typical desktop choices
01:10 wizzyrea yeah, I've used both of those
01:10 wizzyrea but not debian itself.
01:11 dcook Honestly, I had thought about switching over to Ubuntu
01:11 dcook But after a botched minor upgrade on Ubuntu caused issues on my laptop, I figured I'd go for the stability of Debian on my desktop
01:12 dcook The Ubuntu thing probably wasn't that bad, but it was late and brain was a bit mushy
01:12 dcook Couldn't log in though :/
01:12 dcook Of course, that happened while upgrading Debian, except that I actually sorted that out as it was in the morning
03:49 Amit_Gupta joined #koha
04:58 Amit_Gupta hi all
06:02 Francesca joined #koha
06:07 papa joined #koha
06:17 Francesca joined #koha
06:35 cait joined #koha
06:41 Francesca joined #koha
07:21 cait left #koha
07:33 drojf joined #koha
07:33 drojf morning
07:40 laurence joined #koha
07:56 reiveune joined #koha
07:57 sophie_m joined #koha
07:57 reiveune hello
07:59 paul_p joined #koha
08:04 cait joined #koha
08:10 cait morning #koha
08:23 gaetan_B joined #koha
08:23 gaetan_B hello
08:24 wilfrid joined #koha
08:59 * magnuse waves
09:11 Viktor joined #koha
09:11 Francesca joined #koha
09:19 Joubu morning
09:20 cait morning Joubu
09:46 viktorsarge_ joined #koha
09:53 LibraryClaire joined #koha
09:53 LibraryClaire morning #koha
09:55 cait morning LibraryClaire :)
09:55 LibraryClaire hi cait :)
09:56 magnuse hiya LibraryClaire
09:57 * LibraryClaire waves
10:04 * magnuse translates
12:15 khall joined #koha
12:31 cait Joubu++
12:31 cait taking care of the bad bugs
12:31 geek_cl joined #koha
12:44 meliss joined #koha
12:49 oleonard joined #koha
12:49 oleonard Hi #koha
12:50 LibraryClaire hi oleonard
13:01 cait really quiet here currently, you can feel the holidays are close :)
13:02 LibraryClaire 1.5 more days left :))
13:05 oleonard It's not the holidays, it's everyone staying offline to avoid Star Wars spoilers.
13:06 LibraryClaire haha
13:06 LibraryClaire I saw it Friday, am now safe
13:07 barton joined #koha
13:08 cait :)
13:08 cait just one question: do i want to see the new movie? i love the old 3 movies... the new ones not so much
13:09 oleonard cait: In my opinion you do want to see the new movie.
13:10 LibraryClaire yes
13:10 cait I will trust you :)
13:10 LibraryClaire I would be quite happy to see it again
13:11 tcohen joined #koha
13:15 * ashimema wants to see it..
13:15 * ashimema doubts he's going to have a child free moment to get out and see it any time soon.
13:16 * ashimema has just been catching up on the perl advent calendar..
13:16 ashimema why have I never used Smart::Comments..
13:16 ashimema and 'ooh, signatures.. shiny' come to mind :)
13:16 oleonard The "Your suggestions for a new name of Koha NA" thread is really embarrassing.
13:17 cait ashimema: link? :)
13:17 * cait sends oleonard cookies
13:17 ashimema http://www.perladvent.org/2015/
13:17 cait thx ashimema :)
13:17 ashimema http://www.perladvent.org/2015/2015-12-11.html
13:17 ashimema and
13:17 ashimema http://www.perladvent.org/2015/2015-12-21.html
13:18 ashimema are of particular insterest for those two comments ;)
13:18 ashimema but allot of the articles of interesting
13:19 ashimema so little 'stuff' out there actually specifies a perl version though.. so if your relying on cpan modules your unlikely to be able to use allot of 'features' :(
13:20 ashimema even mojolicious is fairly pinned at a supported perl version from days past.. they're love to use signatures but can't really without upsetting allot of their downstream ecosystem.
13:26 kidclamp joined #koha
13:31 * druthb finds the "new name" thread, and gets out the popcorn.
13:31 cait the last one from mirko is... going to be interestng
13:32 LibraryClaire hah
13:33 tcohen morning
13:33 tcohen morning
13:37 drojf joined #koha
13:37 drojf hi
13:37 cait drojf: not sure if that was brave or not ;)
13:37 drojf ?
13:38 cait your last email :)
13:38 drojf what exactly?
13:38 drojf ah. oh haha
13:38 oleonard drojf++
13:39 drojf but seriously, it's hard to understand from the outside
13:43 cait travelling today?
13:44 drojf yup
13:44 cait do i have to worry? :P
13:45 drojf huh?
13:46 cait just joking, travelling because of the holidays?
13:50 cait hmpf :P
13:54 * druthb hmpfs at drojf too
13:55 drojf come on, group hmpfing against a single person is not fair
13:56 liw hmpfs is not a filesystem I have heard of
13:57 druthb You earned extra hmpfs, drojf.
13:57 drojf why? what did i do? :(
13:58 druthb Don't mess with the cait!  :P
14:00 magnuse ashimema: mtj  was keen to use Smart::Comments a while back, i think. "grep -rn "Smart::Comments" *" gives you 8 results, all commented out
14:00 magnuse (in koha, that is)
14:05 nengard joined #koha
14:06 magnuse hmpfs himself into translating those last 560 words
14:12 JoshB joined #koha
14:13 Dyrcona joined #koha
14:17 talljoy joined #koha
14:19 Cybermon joined #koha
14:21 tcohen we should re-design our XSLTs for the UI, so people can actually take advantage of xslt capabilities
14:22 Cybermon hello
14:22 cma joined #koha
14:24 oleonard Man, Koha really is crap at limiting holds by item type. We shouldn't even pretend it's possible.
14:27 magnuse \o/ translation of 3.22 done! (at least the parts i care about)
14:29 tcohen how is it possible that we make people maintain their own xslt forkto just tweak some fields?
14:29 mario_ joined #koha
14:31 Cybermon i have problem for fine. not changed 0 of my fine grace.
14:31 burdsjm joined #koha
14:33 eythian @later tell drojf you're offline, I can only assume you've crossed borders and don't have roaming on. Will see you at Centraal!
14:33 huginn eythian: The operation succeeded.
14:34 magnuse @later tell ashimema see also bug 7218
14:34 huginn magnuse: The operation succeeded.
14:34 ashimema :)
14:34 cait oleonard++
14:36 Joubu ashimema: with a good/used logger, we don't need Smart::Comments
14:36 cait eythian: lol
14:36 ashimema I wasn't really advocating it for Koha ;)
14:36 ashimema more liking the look of it for my own uses ;)
14:36 ashimema mostly.. 'it looks like a good tool for deciphering what some other persons scripts are doing' in the future ;)
14:36 cait tcohen: we DO maintain our own little fork ;)
14:37 cait so i'd say very likely - as we try to avoid customizations quite strictly usually
14:37 ashimema ashamedly.. most of us do cait
14:37 * ashimema needs more tea
14:37 oleonard Oh I guess I should be specific: Koha is crap at limiting holds by item-level item type.
14:38 tcohen yes, but what is the point of having a stylesheet-like tool, and not take advantage of it?
14:38 * ashimema just got a sneaky peak at tomorrows advent entry.. tis all about Mojo::UserAgent :)
14:38 tcohen we could have templates for each thing we show, and let the users "overrride" only that template
14:38 oleonard Not thrilled about this message, either: "Owen Leonard can only place a maximum of total holds." I think somebody a number there.
14:38 tcohen or even add new ones
14:38 cait oleonard: hm strange - i think it does work to some extend
14:39 Cybermon any bugs related circulation of librarian for koha 3.22. when we make circulation, error Koha Session Time Out, when we make circulation by super librarian. it works.
14:39 eythian oleonard: that thread is ridiculous/entertaining. Half the people replying aren't listening to the other half at all.
14:39 cait oleonard: but we are mostly only using the 'no holds allowed' option
14:39 cait tcohen: i totally agree
14:39 eythian Rilarious must be the word
14:40 cait Cybermon: hm did you flush your cache/cookies after the update?
14:40 cait i have seen some weird things happening with old cookies
14:40 oleonard eythian: It's a curious mix of jokey answers and accusations of racism :|
14:41 Cybermon @cait. Thanks. Let me try it. other problem is not showing patron photo too. only works for super librarian
14:41 huginn Cybermon: I'll give you the answer just as soon as RDA is ready
14:41 cait Cybermon: for that i'd check the permissions and pref - just to make sure
14:42 Cybermon @huginn thanks, I wanna know the RDA too
14:42 huginn Cybermon: I'll give you the answer just as soon as RDA is ready
14:42 oleonard What did Bug 12632 do, if not enable hold limits for items with item level itemtypes?
14:42 huginn Bug http://bugs.koha-community.org[…]_bug.cgi?id=12632 major, P5 - low, ---, kyle, Pushed to Stable , Hold limits ignored for record level holds with item level itemtypes
14:42 cait oleonard: i think i am thinking of a different setting - was thining about the holds rules on the circulation condition page
14:43 Cybermon @cait, which permissions and pref.
14:43 huginn Cybermon: I suck
14:43 cait oleonard: i think actually kyle's patch is about using the record level itemtype for tte maxreserves setting
14:44 cait checking
14:44 cait patronimages system preference
14:44 oleonard cait: That's not how it looks based on the test plan.
14:45 cait batch_upload_patron_images permission
14:45 oleonard Cybermon: You don't need to put @ in front of names. It confuses huginn the bot.
14:45 Cybermon cait. thanks. let me try it.
14:45 Cybermon okay oleonard
14:46 cait oleonard: maybe the difference is in the type of hold? record level = record itemtype, item level - item itype?
14:48 oleonard khall around?
14:49 Cybermon my circulation fine is not working always with 0. any things to remind to configure,
14:50 cait Cybermon: what ddo you mean by circulation fine and where have you configured it?
14:52 Cybermon yes. I have circulation rule for Defining circulation and fine rules for all libraries.
14:54 amyk joined #koha
14:55 burdsjm joined #koha
15:02 cait did you change the finesmode preference, Cybermon?
15:04 Cybermon I am planning it on tomorrow.
15:07 Cybermon before do it, i would like clarify that we have about 300 cost for each book of home loan per day, fine amount is about 1000 for each book per day after when finished date of home loan period.
15:08 cait the rental fne is a one time fine
15:08 cait only on checkout and for renewal, not per day
15:09 cait so there is only a one time fee before the book gets overdue, then you can charge daily
15:09 burdsjm_ joined #koha
15:09 Cybermon yes rental fine is one time. depending how many days. 3 days = 900 for each book. etc
15:12 Cybermon cait, would you mind to send your email contact ?
15:12 oleonard Cybermon: It's not polite to ask to contact someone here directly, since everyone is a volunteer.
15:13 Cybermon sorry oleonard
15:13 cait yes, sorry, i can only help here if time permits
15:14 cait you canalso ask questions on the mailnig list of course
15:14 Cybermon sure.
15:15 Cybermon thanks again your help. Cait
15:15 Cybermon and time too
15:16 Cybermon actually, I guess that we are in time differences, that is why asked contact here. anyway.
15:24 Cybermon bye all, see you
15:32 * cait stares at a list of relator codes and sighs
16:13 rocio joined #koha
16:14 talljoy joined #koha
16:18 reiveune bye
16:18 reiveune left #koha
16:46 talljoy joined #koha
17:06 bora joined #koha
17:06 bora Hello
17:06 bora i am look for help on koha upgrad version
17:07 bora i want to upgrad my current version 3.14 to 3.22
17:07 bora anyone can help please
17:07 bora ?
17:08 bora hello
17:08 bora can u help me please
17:08 bora ?
17:09 * ashimema is clocking off now.. bad timing bora
17:10 kidclamp hi bora, what kind of install is your current version?
17:10 bora 3.12 i am look to update to version 3.22
17:12 bora i want o update from koha version 3.12 to 3.22
17:12 bora kidclamp a you there ?
17:12 kidclamp do you know how the system was originally installed?
17:13 bora i install on debian os
17:13 kidclamp installed using the debian packages or from source?
17:13 burdsjm joined #koha
17:14 bora i add koha source to debian
17:14 bora on /etc/apt/deb http://debian.koha-community.org/koha stable main
17:15 bora i have add this to etc/apt/sources.list
17:15 kidclamp sounds like a package install
17:15 kidclamp http://wiki.koha-community.org[…]rade_Instructions
17:16 kidclamp if oyu are running in production I would ensure you have backups etc
17:16 bora this is for ubuntu
17:16 bora but i am install on debain
17:16 bora yes, that is package install on debian
17:16 kidclamp the method should be the same
17:16 bora do this methos for ubuntu work  with debian ?
17:17 cdickinson_ joined #koha
17:18 bora sorry have u try this and its work for u ?
17:21 kidclamp not in a production environment, not a sysadmin :-)
17:21 kidclamp the procedure is very basic, and everything "should" go smoothly
17:21 kidclamp but if you are unsure of what you are doing you might want to find someone who can help fully in case of any problem
17:22 bora ok
17:22 bora thank kidclamp
17:23 cait left #koha
17:23 bora its could be nice if i can keep in touch with you on google plus
17:28 kidclamp bora I don't really use it, but you can often find me here
17:28 kidclamp the listservs are another good place for questions as you don't have to rely on catching the right time
17:28 kidclamp lists?
17:28 kidclamp listservs?
17:29 kidclamp https://koha-community.org/sup[…]ha-mailing-lists/
17:30 bora ok
17:30 bora thank
17:45 oleonard Now we're into the "Why should this group be the way it is?" phase of the KohaNA-renaming thread. Because the people who showed up to the meetings said so?
18:22 Joubu bye #koha
18:40 laurence left #koha
18:42 geek_cl joined #koha
19:04 gaetan_B bye
19:32 aleisha joined #koha
20:03 kathryn joined #koha
20:13 wizzyrea hi oleonard :D
20:14 oleonard Hi wizzyrea
20:15 eythian hi wizzyrea
20:16 wizzyrea heya :D
20:21 oleonard And bye wizzyrea (and all) :D
20:21 wizzyrea Star wars! Spoilers! OMGZORS.
20:21 wizzyrea bye oleonard!
20:21 wizzyrea he's so fast on that quit button.
21:28 amyk joined #koha
21:46 grharry joined #koha
22:00 francesca joined #koha
22:00 francesca Hi
22:02 wizzyrea hi francesca
22:03 cait1 joined #koha
22:03 * cait1 waves
22:05 eythian hi cait1
22:05 cait1 hello
22:05 nengard left #koha
22:06 francesca joined #koha
22:12 francesca joined #koha
22:29 * dcook waves
22:50 francesca joined #koha
22:54 wizzyrea hi dcook
22:54 eythian https://blog.kallisti.net.nz/2[…]entrum-amsterdam/ <-- I started a sort of project
22:55 dcook heya wizzyrea
22:55 wizzyrea \o/ projects!
22:55 wizzyrea catchy name
22:55 dcook hehe
22:56 dcook I like that it's in alphabetical order
22:56 wizzyrea same
22:59 alex_ joined #koha
22:59 eythian secretly, it just makes it easier to keep track of :)
23:00 dcook How many museums are there?
23:00 * wizzyrea blames the librarian blood
23:00 dcook Ah, there's a list
23:00 * dcook should really see more of Sydney one day
23:00 wizzyrea I have a few more wellington ones to see
23:00 grharry Hello Koha!
23:01 eythian dcook: yeah, I just pasted all the 'a' ones into a todo list, and tick them off as I go. Then the 'b's, and so forth
23:01 wizzyrea ^.^
23:01 eythian wizzyrea: it's because I was rubbish at doing the wellington ones that I'm doing this :)
23:02 wizzyrea I really want to get over to the katherine mansfield house. It just never seems to happen.
23:04 grharry I am running v 3.22 and I notice that OAI services are really really slowwwww !!!!
23:05 wizzyrea hmm
23:05 grharry I came up to the conclusion that the SQL query is to blame !
23:05 grharry that consists of
23:05 grharry 3 joins
23:06 grharry and a UNION
23:06 grharry and lots of DATE(timestamp) functions
23:07 grharry I have no idea how to find out where and what to optimize
23:07 eythian grharry: it's a good chance to learn the 'explain' mysql command :)
23:07 grharry since I am not aware of any profiler mysql  tool
23:07 eythian maybe there's a missing index or something
23:08 grharry eythian: So far all indexes seem to be ok
23:08 eythian explain will tell you in graphic details what's going on
23:09 cait1 grharry: hm possible it has to do with the new deleted records support?
23:09 cait1 that would explain the join
23:09 cait1 probably on deleted* ?
23:09 grharry I tried the queries
23:09 grharry without the deleted records
23:10 grharry I am sure that the DATE(timestamp) and timestamp
23:10 grharry and comparisons in the where clause
23:10 grharry SLOW things down a lot !
23:11 grharry this is a killer NO 1 "WHERE timestamp >= '1970-01-01 00:00:00' AND timestamp <= '2015-12-21 23:59:59'"
23:11 eythian is there an index on the timestamp column?
23:11 dcook ^
23:11 grharry killer NO 2 "WHERE DATE(timestamp) >= '1970-01-01T00:00:00Z' AND DATE(timestamp) <= '2015-12-21T23:59:59Z'  "
23:11 grharry YES
23:11 grharry there are indexes
23:12 grharry show create table ....
23:12 eythian are they being used?
23:12 dcook Explain would probably show that
23:12 dcook At least explain analyze would in postgres..
23:12 grharry hm ...
23:12 grharry I have no idea if they are used
23:12 grharry :(
23:13 dcook Might be useful: http://dev.mysql.com/doc/refma[…]sing-explain.html
23:14 cait1 hm that doesn#t seem to make sense
23:14 cait1 why compare a date to a timestamp?
23:14 dcook True true
23:14 dcook It's probably just passing it in straight
23:14 dcook Even though Koha only supports date granularity for OAI
23:15 cait1 hm should refomat to database format and then compare i guess?
23:15 * dcook thinks the timestamp/date/granularity thing should be revisited at some point, but he doesn't have time for it these days
23:15 * eythian goes to bed. later all!
23:16 grharry ok explain says indexes are used
23:16 wizzyrea sleep well :)
23:16 grharry GN
23:16 grharry :)
23:16 dcook night eythian
23:16 francesca_ joined #koha
23:17 dcook In terms of speed, it also depends on database size
23:17 grharry cait1: changing DATE(timestamp) to timestamp .... does not improve a lot
23:17 dcook If you have 1 million records between those dates, it's probably going to take a while
23:18 cait1 grharry: maybe date to date would... but still makes no sense the way it is :)
23:18 grharry dcook: the problem is that it takes always "a while " to fetch 50 by 50 records
23:19 grharry cait1: I don't disagree! I think the whole approach logic
23:19 grharry requires some re-evaluation!
23:19 dcook grharry: What's "a while"?
23:20 grharry 1 min
23:20 dcook Hmm..
23:20 grharry for every 50 recs
23:20 grharry for a 500.000 recs
23:20 grharry it's 50000 mins
23:21 dcook Hmm, I just got 50 records from a different OAI-PMH server in 6 seconds, so I can understand 60 seconds being a while :p
23:21 dcook Although that server probably has way better servers than you do
23:21 dcook Err
23:21 papa joined #koha
23:21 dcook That server is probably much nicer :p
23:22 dcook grharry: In theory, the first harvest should always be the worst
23:22 grharry 833 hours !!!!  no way
23:22 grharry v3.20.3 was a lot faster
23:22 dcook Good point
23:23 dcook I think on 3.8 or 3.10 I harvested about 70,000 records in 8 hours or so
23:23 dcook So 28800 seconds
23:24 dcook Actually, that wasn't just downloading. That was everything..
23:24 dcook So probably much faster than that
23:24 grharry there is always a "but"
23:24 dcook Well, you could compare v3.20.3 with v3.22
23:24 grharry 3.20.xx did not offer items support
23:24 grharry I think
23:24 dcook Probably
23:24 dcook I can't remember when that came about
23:25 dcook That would also slow it down
23:25 grharry yes
23:25 dcook Probably significantly
23:25 dcook Are you using items as well?
23:25 grharry I tested both
23:25 grharry Both are not acceptable !!!
23:25 rocio left #koha
23:26 grharry Confused !!! :|
23:29 grharry 51 rows in set, 3 warnings (58.00 sec)
23:29 dcook 3 warnings? I assume that has to do with the timestamps
23:29 alex_ 0
23:29 alex_ down vote
23:29 alex_ favorite
23:29 alex_
23:29 alex_ I am trying to clone and set up my kohadevbox on my Ubuntu VirtualBox. But after writing in 'vagrant up' to start a new dev box I get the error:
23:29 alex_ "The box you're adding has a name different from the name you requested. For boxes with metadata, you cannot override the name. If you're adding a box using vagrant box add, don't specify the --name parameter. If the box is being added via a Vagrantfile, change the config.vm.box value to match the name below. Requested name: chef/debian-7.8 Actual name: bento/debian-7.8 "
23:29 alex_ My research online suggested that I needed to change the vagrantfile from chef/debian-7.8 to bento/debian-7.8 When I did this I found that I got another error message saying:
23:29 alex_ "The SSH command responded with a non-zero exit status. Vagrant assumes that this means the command failed. The output for this command should be in the log above. Please read the output to determine what went wrong." But when I search localhost:8080 in my web browser I get the Koha OPAC interface appearing. So is it correct to change chef/debian-7.8 to bento/debian-7.8 in the vagrantfile?
23:29 dcook grharry: Well, you have options. You can file a bug report, you can work on a fix yourself, you can pay someone to try to fix it for you.
23:30 grharry You can file a bug report = :)
23:30 dcook Excuse me?
23:31 dcook http://bugs.koha-community.org/bugzilla3/
23:31 grharry Very slow there too! :)
23:31 dcook O_o
23:32 grharry any way
23:32 talljoy joined #koha
23:33 wizzyrea alex_: that message doesn't seem to have any functional consequences
23:33 wizzyrea vagrant ssh still works.
23:33 grharry thanks for u help!
23:33 dcook No worries. I hope you're able to find a solution.
23:34 cait joined #koha
23:34 cait sorry... laptop died
23:34 wizzyrea ^.^ it happens
23:35 dcook grharry: For what it's worth, I doubt I'll be looking into that issue any time soon, as I probably won't be using anything newer than 3.20.x for a while
23:35 dcook But there might be other people out there who will
23:35 cait filing a bug is always good
23:35 dcook So if you report it on Bugzilla, or on one of the Koha listservs, it opens up a discussion with others
23:36 dcook Versus the people who just happen to be on IRC when you are online as well ;)
23:36 dcook This is probably one of the least busy times of day I think?
23:36 grharry timestamp is a problem here
23:36 dcook Write it in the bug report for sure then :)
23:37 grharry first part of query SELECT biblioitems.biblionumber, biblioitems.timestamp, marcxml   FROM biblioitems JOIN oai_sets_biblios ON biblioitems.biblionumber = oai_sets_biblios.biblionumber  LIMIT 51 OFFSET 0
23:37 grharry 0 secs
23:37 grharry but no timestamp
23:37 dcook I keep finding I'm using Karen Etheridge's modules... just learned that she lives in Vancouver. That's pretty cool..
23:37 grharry I think it's a mysql usage issue
23:37 grharry and a matter of a really bad query
23:38 grharry I am talking about really really bad sql
23:38 dcook Please feel free to fix it :)
23:38 grharry I am not a MySQL expert
23:38 wizzyrea yep, you get your name in the history if you fix a thing.
23:38 grharry :)
23:39 grharry I sell it to some people too !! :)
23:39 wizzyrea I bet you're more of an expert than you realise.
23:39 wizzyrea give it a go, it might be great.
23:39 grharry No I am not
23:39 grharry I used to be good with ORACLE
23:39 grharry but mysql
23:39 grharry no
23:40 wizzyrea *shrug* as you say
23:40 grharry I dont think mysql is a real database !!
23:40 grharry :)
23:40 dcook ...
23:40 * rangi grins
23:40 wizzyrea well that's all fair, we don't think oracle is a real one.
23:40 rangi exactly
23:40 grharry yep ... sybase is better ?
23:41 * wizzyrea checks the license on koha
23:41 rangi sybase is dead
23:41 wizzyrea yep, still gpl.
23:41 rangi ive had to admin sybase and oracle dbs
23:41 rangi they need way too much care and attention
23:42 wizzyrea they make the plastic baby cry a lot.
23:42 rangi postgres .. i'll give you that one :)
23:42 rangi having said all that
23:43 rangi what you are looking for is explain
23:44 rangi explain query
23:44 rangi will tell you how it is being evaluated
23:44 rangi oh dcook already told you
23:44 rangi if you see writing to tempfile
23:44 rangi or all
23:45 rangi or anything like that, thats a really big hint
23:45 * rangi goes to lunch
23:46 francescam joined #koha

| Channels | #koha index | Today | | Search | Google Search | Plain-Text | plain, newest first | summary
http://irc.koha-community.org/koha/2015-12-21
irc.koha-community.org
crawl=CC-MAIN-2020-10
174620
application/http; msgtype=response
sha1:ODMA2PR6AX6TOKM3OZYRTPRZTEW7LVPE
<urn:uuid:cbcac345-6d7c-441c-92ed-d0d9febb2c97>
2020-02-25T10:04:13Z
72.14.190.217
application/xhtml+xml
sha1:62ZX6Z6V7HAVAPXEDUKWXOSZ46LTRBJC
<urn:uuid:fbfe445e-c8c1-4c30-b14b-2c5083b0eed5>
http://irc.koha-community.org/koha/2015-12-21
response
<urn:uuid:eeac545d-6e1b-4839-b169-ee171237236d>
isPartOf: CC-MAIN-2020-10
publisher: Common Crawl
description: Wide crawl of the web for February 2020
operator: Common Crawl Admin (info@commoncrawl.org)
hostname: ip-10-67-67-170.ec2.internal
software: Apache Nutch 1.16 (modified, https://github.com/commoncrawl/nutch/)
robots: checked via crawler-commons 1.1-SNAPSHOT (https://github.com/crawler-commons/crawler-commons)
format: WARC File Format 1.1
conformsTo: http://iipc.github.io/warc-specifications/specifications/warc-format/warc-1.1/