Well one way or the other the latency of the link does seem to be the most
important factor in the problem I'm seeing.
I have three ways to get at the data:
1) log into the remote server using RDP and run the queries locally. even the
most complex ones complete in under a second
2) use JDBC ov
On 27-4-2012 12:03, AngelBlaZe wrote:
>
> for example
> a decimal(10,5) column
> would have using the query above:
> type = 16 And subtype = 2
> precision = 10
> scale = 5
Scale is a negative value, not positive (so a DECIMAL(10,5) has scale -5
(you can interpret it as: move the decimal 5 positio
This is an old problem. Many drivers do local cache-ing, others do their
own SQL parsing (imagine the effort if you are joining two or more
tables from different databases). Many years ago, my company wrote a
driver that did this client-server thing (SQLRunner). We let the server
interprets the SQL
Em 27/4/2012 15:11, Maury Markowitz escreveu:
> Well one way or the other the latency of the link does seem to be the most
> important factor in the problem I'm seeing.
>
> I have three ways to get at the data:
>
> 1) log into the remote server using RDP and run the queries locally. even the
> mo
We are now using the feature in Firebird that allows numerical sorting of
varchar fields ( see below )
however now the length of these fields in RDB$FIELDS.RDB$FIELD_LENGTH is now 4
times the real size of the field. size 80 when domain length is really only 20.
This deceives our application int
found the answer.
there is also a character_length field in the rdb$fields table.
Found solution in archives of this group.
Kind Regards,
Robert.