Time |
Nick |
Message |
06:01 |
pinesol |
News from qatests: Testing Success <http://testing.evergreen-ils.org/~live> |
07:18 |
|
rjackson_isl_hom joined #evergreen |
08:18 |
|
collum joined #evergreen |
08:41 |
|
mmorgan joined #evergreen |
08:55 |
|
Dyrcona joined #evergreen |
08:58 |
Dyrcona |
Acting Library Director: I'm not a library director, but I play one at work. :) |
08:59 |
Dyrcona |
Also, why is a select statement with a long "IN" of barcodes (maybe 2,100) taking so long to run. Hmm.. probably the order by. |
09:01 |
mmorgan |
Dyrcona++ |
09:01 |
Dyrcona |
Oh, sure. There are scheduled reports running.... |
09:01 |
Dyrcona |
Maybe I'll try the other database. |
09:02 |
Dyrcona |
mmorgan: To follow up on something from the Zoom meeting yesterday. I really like that your list editor can put things in buckets. |
09:03 |
mmorgan |
Dyrcona: Yes, it |
09:03 |
mmorgan |
's very popular among our users |
09:03 |
Dyrcona |
We don't do that with metabase because it talks to our read only reports database. I won't connect it the live transaction database for now. |
09:04 |
Dyrcona |
Also, that query ran a bit more quickly without the order by, so I don't have to switch databases. :) |
09:05 |
Dyrcona |
And, I'm mistaken.... Case of glancing at the wrong tab and being distracted... |
09:05 |
mmorgan |
Makes sense, we're wary about scripts making changes to the db, but inserting is less scary than updating :) |
09:05 |
mmorgan |
Dyrcona: I'm impressed how quickly the queries ran in metabase. |
09:07 |
Dyrcona |
John is pretty good with SQL. Also, I've generally found JDBC to be efficient. When doing MVLC's migration, the fastest way that I found to load bibs was a bunch of BatchStatements. Faster than parallel COPY. |
09:07 |
Dyrcona |
I have to step away for a bit. |
09:09 |
Dyrcona |
And, I don't. It has already been a confusing day, and I'm just getting started. |
09:09 |
jeff |
was this a community call, or other? |
09:10 |
csharp |
Dyrcona: sometimes EXISTS/NOT EXISTS is better than IN for certain queries |
09:11 |
mmorgan |
jeff: other, neighbor networks :) |
09:12 |
jeff |
guessed, but wanted to make sure i hadn't missed an opportunity. :-) |
09:15 |
|
sandbergja joined #evergreen |
09:17 |
|
rfrasur joined #evergreen |
09:18 |
Dyrcona |
jeff: Yeah, just NOBLE and CWMARS chatting for the first time in over a year. |
09:18 |
Dyrcona |
csharp: I was just dumping some copy data, so the straightforward query seemed to make the most sense. |
09:22 |
Dyrcona |
Might have been faster to just read the barcodes line by line and dump the data row by row to a file using Perl or Python. |
09:27 |
Dyrcona |
I was just trying to figure why only 1,855 copies from a spreadsheet listing 2,100 updated. Turns out the others were deleted after the spreadsheet was put together. |
12:15 |
|
jihpringle joined #evergreen |
12:34 |
|
collum joined #evergreen |
12:49 |
|
collum joined #evergreen |
13:55 |
jeffdavis |
Is it ok for me to commit code I wrote if other people have signed off on it? |
13:56 |
jeffdavis |
I assume yes, but a bit hesitant |
14:04 |
Dyrcona |
Yes, it is OK. |
14:18 |
jeffdavis |
makes sense, thank you |
15:27 |
|
mmorgan1 joined #evergreen |
15:46 |
Bmagic |
Is there a wiki page somewhere that contains our roadmap for angularizing the dojo interfaces? |
15:49 |
Bmagic |
I found: https://wiki.evergreen-ils.org/doku.php?id=cataloging:angular and https://wiki.evergreen-ils.org/doku.php?id=faqs:evergreen_roadmap:3.4 |
15:51 |
Dyrcona |
There isn't a road map for eliminating Dojo AFAIK, but there is a Lp bug. |
15:53 |
Bmagic |
I'm looking for something for the acq invoice interface |
15:55 |
Dyrcona |
Acq is being reimplemented by EOLI. |
15:56 |
Bmagic |
groovy |
15:57 |
Bmagic |
3.7 has the search interfaces upgraded. But not the invoice interface |
15:57 |
Bmagic |
maybe 3.8? eh? |
15:57 |
Bmagic |
bug 1917482 is annoying |
15:57 |
pinesol |
Launchpad bug 1917482 in Evergreen "Invoice UI fails to load completely" [Undecided,Confirmed] https://launchpad.net/bugs/1917482 |
16:01 |
tsadok |
Quick question about this channel: is keeping it here (on the old Freenode network) a conscious decision, or has the question just not come up yet? |
16:06 |
JBoyer |
Hasn't come up yet, though I know at least a few of us are aware. |
16:23 |
tsadok |
Ok, just curious. |
16:25 |
|
jihpringle joined #evergreen |
16:59 |
pinesol |
News from qatests: Failed Installing OpenSRF pre-requisites <http://testing.evergreen-ils.org/~live//archive/2021-05/2021-05-21_16:00:03/test.7.html> |
17:04 |
|
mmorgan1 left #evergreen |