Re: Are there any benchmarks comparing slick to hibernate or jdbi etc?

[Jason]

I haven't seen any yet, but interested to see how it performs too! Just remember that (I'm sure you know this) that from a developer standpoint, slick allows one to make use of general higher order usefulness (being that it is a Scala no less). Something which is hard to reflect in any benchmark and is subjective, but so powerful when analyzing any tool for it's effectiveness. I take it you could analyze the sql statements being generated, for a general gauge of db performance. -J

On Tue, Apr 2, 2013 at 4:43 PM, gitted <sahme...@gmail.com> wrote:

Hi,

Just learning slick, and was curious if there are any published benchmarks (with code) out there currently?

--
 
---
You received this message because you are subscribed to the Google Groups "Slick / ScalaQuery" group.
To unsubscribe from this group and stop receiving emails from it, send an email to scalaquery+...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

[Flavio W. Brasil]

Hi.

There is http://databen.ch now. It has a Slick implementation.

Please feel fee to send suggestions or pull requests.

-- 

Flávio W. Brasil

[Jason Giedymin]

+1 thanks!

-Jason

[virtualeyes]

Well, that's not good, last place, yikes.

Would it be possible to add ScalaQuery 0.10 to the benchmark?

I do remember Stephan mentioning that Slick would be a bit slower than SQ in the early stages of Slick development.

Thanks for creating the benchmark, interesting results, assumed Hibernate would lag the rest.

[Flavio W. Brasil]

Hi.

The benchmark is using Scala 2.10. There is a compilation of ScalaQuery for it?

-- 

Flávio W. Brasil

[virtualeyes]

No, but I did manage to get ScalaQuery 0.10 to compile against Scala 2.10.

Still on 2.9.2. in production, was just trying to test out Play/Scala 2.10 against existing SQ-based application.

I'm actually not even sure where SQ 0.10 source code is now, maybe still on Slick github somewhere. Just publish-local against the source if you can find it, should work, all the tests passed as I recall, more deprecation warnings though ;-)

Anyway, that's the past, was just curious to have SQ as a comparison.

[Stefan Zeiger]

On 2013-04-11 14:51, virtualeyes wrote:

Well, that's not good, last place, yikes.

Would it be possible to add ScalaQuery 0.10 to the benchmark?

I do remember Stephan mentioning that Slick would be a bit slower than SQ in the early stages of Slick development.

Thanks for creating the benchmark, interesting results, assumed Hibernate would lag the rest.

ScalaQuery may be faster there because it compiles queries faster. Of course, it should not have to recompile them at all. You can do this for selects (and databen.ch makes use of it) but not yet for updates. Since databen.ch consists mostly of updates, I expect this to be a major factor here. Precompiled updates are planned for Slick 2.0:  https://www.assembla.com/spaces/typesafe-slick/tickets/146

And here's the ticket for investigating other possible performance issues uncovered by databen.ch: https://www.assembla.com/spaces/typesafe-slick/tickets/216. If it turns out to be contention due to different locking strategies, we'll have to see if and how we deal with that. Slick is a database library, not a persistence solution, so we haven't seen that as being in scope so far.

PS: Another idea I've been toying with but that hasn't made it to ticket status yet: Unboxed access paths. In addition to precompiling the SQL code I'd also like to generate mappings from and to the DTOs (usually case classes) that avoid polymorphic calls and boxing (like going through tuples). Unboxed converters for case classes could be auto-generated by macros but it will require some changes in the design of the invokers (on which I am working for 2.0).

--
Stefan Zeiger
Typesafe - The software stack for applications that scale
Twitter: @StefanZeiger

See you at Scala Days 2013 in NYC!
June 10th - June 12th
www.scaladays.org

[Stefan Zeiger]

On 2013-04-11 23:51, virtualeyes wrote:

No, but I did manage to get ScalaQuery 0.10 to compile against Scala 2.10.

Still on 2.9.2. in production, was just trying to test out Play/Scala 2.10 against existing SQ-based application.

I'm actually not even sure where SQ 0.10 source code is now, maybe still on Slick github somewhere.

The latest ScalaQuery sources are here: https://github.com/slick/slick/tree/0.10.0-M1