[prev in list] [next in list] [prev in thread] [next in thread] 

List:       haskell-cafe
Subject:    Re: [Haskell-cafe] Haskell SQL backends: How is data handed over?
From:       Olaf Klinke <olf () aatal-apotheke ! de>
Date:       2022-08-12 20:37:59
Message-ID: e0404f5dbd7540852cffeeb18fd248079925e25b.camel () aatal-apotheke ! de
[Download RAW message or body]

Anthony Clayden wrote: 

> What is your evidence that number/String is a concern here? It's all
> happening in-memory.
> 
> Whereas sending whatever to SQL then needs putting it to disk, which is
> orders-of-magnitude slower. (Or is this an in-memory database?)
> 
> This thread has already devoted more cycles to speculation than you're
> going to reclaim through number formatting, methinks.

Very good point. I'm fairly new to SQL, have a solution that works and
started to wonder how efficient it is. Since the way data is passed to
and from the DB engine affects every database interaction, for every
user, I thought it might be worthwile investigating. And as I said
earlier, profiling other code has proved that number parsing can make
up a significant portion of a data-heavy program's CPU time. Thus it's
not speculation entirely. 

Olaf

_______________________________________________
Haskell-Cafe mailing list
To (un)subscribe, modify options or view archives go to:
http://mail.haskell.org/cgi-bin/mailman/listinfo/haskell-cafe
Only members subscribed via the mailman list are allowed to post.
[prev in list] [next in list] [prev in thread] [next in thread]