The mysql tag has no wiki summary.
10
votes
1answer
202 views
Is there a way to print out SQL queries made using DatabaseLink?
I have a Mathematica batch script which makes some MySQL queries using DatabaseLink to store parameters of the run in a database. Recently, I had a run where these queries failed, and there was no ...
9
votes
3answers
381 views
How can I speed up SQL queries in Mathematica?
I have an application that queries a MySQL database many times for data. At the moment, Mathematica and MySQL are running on the same box and yet it takes over 1.6 seconds for the query to run and ...
7
votes
2answers
139 views
DatabaseLink`: MySQL query with client/server compression
I'm trying to reduce transfer time when accessing rows of a mysql table over a network, where each row has a lot of data. Is there a way to enable client-server compression when accessing a mysql ...
7
votes
0answers
146 views
Is there an efficient and elegant way to import huge datasets from a mysql database?
I'm struggling to import huge datasets (up to a couple million rows) from a MYSQL database into Mathematica. I already tried http requests, direct sql calls, as well as implementing a web service, ...
4
votes
4answers
381 views
MySQL Connection Problem
I have a problem with the configuration of the J-Connector plug-in with a MySQL database. Most of the time all works well, but sometimes the connection remains blocked for 2 hours and then it gives ...
2
votes
1answer
139 views
2
votes
0answers
47 views
Can Mathematica use a MySQL ODBC connector?
I have a MySQL database that I connect to using Mathematica and would like to distribute my Mathematica code to others. We already have ODBC DSNs setup on peoples machines using the MySQL ODBC ...
