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]
https://support.office.com/en-us/article/Access-2010-specifications-1e521481-7f9a-46f7-8ed9-ea9dff1fa854
On 8/5/15 3:07 PM, Harper, Cynthia 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 period(s). I have
been importing these into Access then grouping them by bib record. I think that
I've reached the limits of scalability for Access for this project now, with
250,000 item records. Does anyone do this in R? My other go-to- software for
data processing is RapidMiner free version. Or do you just use MySQL or other
SQL database? I was looking into doing it in R with RSQLite (just read about
this and sqldf http://www.r-bloggers.com/make-r-speak-sql-with-sqldf/ )
because I'm sure my IT department will be skeptical of letting me have MySQL on
my desktop. (I've moved into a much more users-don't-do-real-computing kind of
environment). I'm rusty enough in R that if anyone will give me some start-off
data import code, that would be great.
Cindy Harper
E-services and periodicals librarian
Virginia Theological Seminary
Bishop Payne Library
3737 Seminary Road
Alexandria VA 22304
char...@vts.edu<mailto:char...@vts.edu>
703-461-1794
