On Wed, Jan 19, 2011 at 09:15, rygorr wrote:
> This was it. The overhead was in creating the handle.
>
>
I can't remember who told me this: "Always blame the network".
In finer detail, the conversation was about things that use the network and
are so very much slower than you anticipate.
--
Y
This was it. The overhead was in creating the handle.
When I moved the doseq inside the with-connection it solved the problem.
Thanks
On Jan 19, 2011, at 7:24 AM, Meikel Brandmeyer wrote:
> Hi,
>
> On 18 Jan., 19:32, rygorr wrote:
>
>> (doseq [x (range 2000)]
>> (with-connection db
>>
Hi,
On 18 Jan., 19:32, rygorr wrote:
> (doseq [x (range 2000)]
> (with-connection db
> (insert-values :test
> [:value] [x])))
> db is the com.mysql.jdbc.Driver connection string.
Move the with-connection outside the doseq.
(with-connection db
(doseq [x (range
I suspect that ClojureQL and with-connection are opening and closing
the connection for every query, whereas the Java and Perl versions are
reusing their connections.
Try adding a connection pool to the mix.
On Tue, Jan 18, 2011 at 19:32, rygorr wrote:
> I'm currently doing some preliminary perf
