On Wed, Aug 5, 2015 at 1:07 PM, Harper, Cynthia char...@vts.edu wrote:
Hi all. What are you using to process circ data for ad-hoc queries. I
usually extract csv or tab-delimited files - one row per item record, with
identifying bib record data, then total checkouts over the given time
than just taking the lazy
approach every time...
Cindy
-Original Message-
From: Code for Libraries [mailto:CODE4LIB@LISTSERV.ND.EDU] On Behalf Of Kevin
Ford
Sent: Wednesday, August 05, 2015 5:16 PM
To: CODE4LIB@LISTSERV.ND.EDU
Subject: Re: [CODE4LIB] Processing Circ data
On the surface
] Processing Circ data
On Wed, Aug 5, 2015 at 1:07 PM, Harper, Cynthia char...@vts.edu wrote:
Hi all. What are you using to process circ data for ad-hoc queries. I
usually extract csv or tab-delimited files - one row per item record,
with identifying bib record data, then total checkouts over
-
From: Code for Libraries [mailto:CODE4LIB@LISTSERV.ND.EDU] On Behalf Of Kyle
Banerjee
Sent: Thursday, August 06, 2015 12:34 PM
To: CODE4LIB@LISTSERV.ND.EDU
Subject: Re: [CODE4LIB] Processing Circ data
On Wed, Aug 5, 2015 at 1:07 PM, Harper, Cynthia char...@vts.edu wrote:
Hi all. What
Rochester, NY 14627
585.275.1059
ddun...@library.rochester.edu
-Original Message-
From: Code for Libraries [mailto:CODE4LIB@LISTSERV.ND.EDU] On Behalf Of
Harrison G. Dekker
Sent: Thursday, August 06, 2015 12:08 PM
To: CODE4LIB@LISTSERV.ND.EDU
Subject: Re: [CODE4LIB] Processing Circ data
[mailto:CODE4LIB@LISTSERV.ND.EDU] On Behalf Of
Kevin Ford
Sent: Wednesday, August 05, 2015 5:16 PM
To: CODE4LIB@LISTSERV.ND.EDU
Subject: Re: [CODE4LIB] Processing Circ data
On the surface, your difficulties suggest you may need look at a few
optimization tactics. Apologies if these are things
Hi all. What are you using to process circ data for ad-hoc queries. I usually
extract csv or tab-delimited files - one row per item record, with identifying
bib record data, then total checkouts over the given time period(s). I have
been importing these into Access then grouping them by bib
Another option might be to use OpenRefine http://openrefine.org - this should
easily handle 250,000 rows. I find it good for basic data analysis, and there
are extensions which offer some visualisations (e.g. the VIB BITs extension
which will plot simple data using d3
Hi Cindy,
This doesn't quite address your issue, but, unless you've hit the 2 GB
Access size limit [1], Access can handle a good deal more than 250,000
item records (rows, yes?) you cited.
What makes you think you've hit the limit? Slowness, something else?
All the best,
Kevin
[1]
Sent: Wednesday, August 05, 2015 4:23 PM
To: CODE4LIB@LISTSERV.ND.EDU
Subject: Re: [CODE4LIB] Processing Circ data
Hi Cindy,
This doesn't quite address your issue, but, unless you've hit the 2 GB Access
size limit [1], Access can handle a good deal more than 250,000 item records
(rows, yes
: Wednesday, August 05, 2015 4:23 PM
To: CODE4LIB@LISTSERV.ND.EDU
Subject: Re: [CODE4LIB] Processing Circ data
Hi Cindy,
This doesn't quite address your issue, but, unless you've hit the 2 GB Access size limit
[1], Access can handle a good deal more than 250,000 item records (rows,
yes?) you cited
11 matches
Mail list logo