Re: [sqlite] Re: Any Ideas to speed up CAST

2007-12-22 Thread Mag. Wilhelm Braun
Thanks Igor that makes sense about integers. I would be interesting about your point of keeping the precision in floating point values without storing it as strings. would be a great help as I have a few cases like that. Thanks so much for your kind help W.Braun Igor Tandetnik wrote:

[sqlite] Re: Any Ideas to speed up CAST

2007-12-22 Thread Igor Tandetnik
Mag. Wilhelm Braun <[EMAIL PROTECTED]> wrote: because of accuracy I use everywhere text entries even for numerical entries. You seem to be storing integer values as text. What kind of accuracy improvement do you expect from this? Integers are stored losslessly already. I could remotely