Forum OpenACS Q&A: Re: Just the database API

Collapse
Posted by Jeff Davis on
It mattered but this was for a page that was constructed from about 2k rows (aggregation of company financials where each table element came from one or more rows). In most cases this would not make that much of a difference. I did some testing and it looked like by going directly to tcl variables from the db you might cut the time on a query like that by 25% or so. I makes sense that it would matter for the some things for the same reason that whenever you read things about expr it tells you to use { }'s.

It's not that common a use case though.

The other thing was that tcl's handling of floats and ints etc is problematic. This turned up when doing these financial calculations since you would have round numbers going into a formula and get the wrong result like this:

% set x 1
1
% set y 3
3
% expr $x / $y
0
I also thought about making it so that floats were returned with .0 tacked on to avoid this sort of problem.