I have a feeling it may be time for me to learn some grown-up programming
skills, and I hope someone here might be able to help.
I have a PHP script chewing over a large MySQL query. It's creating a handful
of big associative arrays in the process, and punks out after the arrays get to
32MB.
On Tue, Aug 30, 2011 at 12:56 PM, Ken Irwin kir...@wittenberg.edu wrote:
I have a feeling it may be time for me to learn some grown-up programming
skills, and I hope someone here might be able to help.
I'm basically building a big associative array encoding the name of the
borrowing
Build multiple insert strings to max=packet size and only then send to
mysql it gives a similar speed up to load data infile, and you dont
need the arrays.
INSERT [INTO] tbl_name [(col_name,...)]
{VALUES | VALUE} ({expr | DEFAULT},...),(...),...
in a test I did years ago on a slow (compared
On Aug 30, 2011, at 3:55 PM, Simon Spero wrote:
On Tue, Aug 30, 2011 at 12:56 PM, Ken Irwin kir...@wittenberg.edu wrote:
I have a feeling it may be time for me to learn some grown-up programming
skills, and I hope someone here might be able to help.
[trimmed]
Sometimes it can make sense
Please share this announcement with colleagues who would be interested.
JOB ANNOUNCEMENT:
Associate University Librarian for Research and Scholarly Communication
Oregon State University Libraries
Oregon State University Libraries seeks an innovative, dynamic, and experienced
library leader to
LYRASIS is seeking to engage consultants to create decision support tools in
the form of whitepapers, self-guided assessments, and worksheets for libraries
considering open source software. This work is funded by a grant from the
Andrew W. Mellon Foundation to help libraries of all types