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:

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 understand storing floating point values as strings 
(though there are better ways to preserve precision) - but integers?


Igor Tandetnik

- 


To unsubscribe, send email to [EMAIL PROTECTED]
- 







-
To unsubscribe, send email to [EMAIL PROTECTED]
-



[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 understand storing floating point values as strings 
(though there are better ways to preserve precision) - but integers?


Igor Tandetnik 



-
To unsubscribe, send email to [EMAIL PROTECTED]
-