| Time |
Nick |
Message |
| 06:52 |
* Ilie- |
serus la toti .. poate face cineva un user la el/ea in bnc ? |
| 07:31 |
|
Callender joined #evergreen |
| 07:51 |
|
krvmga joined #evergreen |
| 08:27 |
|
collum joined #evergreen |
| 08:51 |
|
bos20k joined #evergreen |
| 08:59 |
|
Dyrcona joined #evergreen |
| 09:16 |
|
maryj joined #evergreen |
| 09:33 |
|
yboston joined #evergreen |
| 09:49 |
* Dyrcona |
wonders how dbi will cope with a 12MB query.... List of 1.5 million bibs in a not in (...). |
| 09:54 |
jeff |
that sounds like something that should be avoided. :-) |
| 09:56 |
eeevil |
if there's ever been a case for a temp table and an exists clause.... |
| 09:59 |
Dyrcona |
Yeah, I'm thinking about that. I have the list in a text file. |
| 10:00 |
Dyrcona |
and not exists (select id from temp_table) --Right? |
| 10:00 |
Dyrcona |
hrm... select * from temp_table where id = ? -- rather. |
| 10:03 |
Dyrcona |
Yeah, I'll put the ids in a "temp table." |
| 10:08 |
Dyrcona |
And do "and not exists (select 1 from temp_table where temp_table.id = biblio.record_entry.id)" since I'm selecting from biblio.record_entry. |
| 10:09 |
Dyrcona |
Something tells me that might be slow... ;) |
| 10:11 |
Stompro |
eeevil++, thanks for responding to my A/T json join question. |
| 10:38 |
|
finnx joined #evergreen |
| 10:40 |
|
finnx joined #evergreen |
| 10:40 |
csharp |
well, looks like it's time to learn all about EDI INVOIC messages :-/ |
| 10:40 |
csharp |
two weeks ago it was all about ORDRSP |
| 10:40 |
jeff |
INV? |
| 10:40 |
jeff |
OIC. |
| 10:40 |
csharp |
heh |
| 10:41 |
berick |
welcome to the party csharp |
| 10:42 |
|
finnx joined #evergreen |
| 10:44 |
|
finnx joined #evergreen |
| 10:45 |
|
finnx joined #evergreen |
| 10:45 |
csharp |
berick++ |
| 10:46 |
|
finnx joined #evergreen |
| 11:04 |
|
Christineb joined #evergreen |
| 11:12 |
eeevil |
Dyrcona: actually, you can prob just do " where id not in (select id from temp_table)" |
| 11:13 |
Dyrcona |
eeevil: Yeah, not sure if that makes much difference over the not exists. |
| 11:13 |
eeevil |
should be faster on newer pg |
| 11:13 |
eeevil |
maybe |
| 11:13 |
Dyrcona |
We're on 9.2. |
| 11:14 |
eeevil |
anyway, testing would tell. either will be faster than a straight in lust |
| 11:14 |
eeevil |
list |
| 11:14 |
Dyrcona |
Less memory intensive, too. :) |
| 11:19 |
eeevil |
aye |
| 11:32 |
|
sandbergja joined #evergreen |
| 12:12 |
bshum |
Zesty Zapus, really? |
| 12:17 |
berick |
heh |
| 12:18 |
bshum |
The real question isn't this next one, but what'll be 17.10 |
| 12:18 |
bshum |
If it starts back over at A |
| 12:20 |
berick |
they'll celebrate their maturity with the AARP release |
| 12:35 |
Dyrcona |
Well, they didn't start out being alphabetical. |
| 12:44 |
tsbere |
bshum: Maybe they will go the Excel Columns route and try and do AA, AB, AC, etc.... ;) |
| 12:47 |
jeff |
Hrm. Given a scenario of "branch starts using shelving location Foo", followed by "other branches like the idea"... I'm tempted to change the owning_lib on the asset.copy_location to higher up the tree, rather than making a new system-level location and migrating branch 1 off of the original (or having two for a while). |
| 12:47 |
Dyrcona |
jeff: Either way works. I've done both. :) |
| 12:48 |
* dbs |
just upgraded his primary laptop to Fedora "no cutesy names" 25 beta |
| 12:48 |
Dyrcona |
I.E. moved a branch or system acpl higher, or created new ones for branches, etc. |
| 12:48 |
Dyrcona |
jeff: One thing to consider is do they want different settings for holdable and circulate? |
| 12:48 |
jeff |
Dyrcona: not in this case. |
| 12:49 |
Dyrcona |
jeff: In that case, "moving" the existing one up the tree is probably better, IMO. |
| 12:51 |
dbwells |
bshum: too bad, was hoping for Zesty Zyzzyva ;) |
| 13:19 |
|
jihpringle joined #evergreen |
| 13:24 |
|
jvwoolf joined #evergreen |
| 14:23 |
|
ssieb joined #evergreen |
| 15:13 |
|
kmlussier joined #evergreen |
| 17:10 |
|
jvwoolf left #evergreen |
| 21:04 |
|
finnx1 joined #evergreen |
| 21:47 |
|
Christineb joined #evergreen |
| 21:55 |
|
Christineb joined #evergreen |
| 22:31 |
|
finnx1 left #evergreen |
