Subject | Re: [firebird-support] Max number of query parameters? |
---|---|
Author | Kjell Rilbe |
Post date | 2011-08-31T14:36:32Z |
Den 2011-08-31 15:49 skrev Kjell Rilbe såhär:
column it accepted up to 162 parameters.
But on the same table, it seemed to accept several thousand parameters
on a bigint column.
So does this mean that there's no hard limit to the COUNT of parameters,
but there IS a limit to the data SIZE required by the parameters?
If so, what is that limit?
Kjell
--
--------------------------------------
Kjell Rilbe
DataDIA AB
E-post: kjell@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64
> What is the maximum number of query parameters for Firebird? Has itA bit of testing: with a query testing for equality with a varchar
> changed between 2.1 and 2.5 and will it change in 3.0?
column it accepted up to 162 parameters.
But on the same table, it seemed to accept several thousand parameters
on a bigint column.
So does this mean that there's no hard limit to the COUNT of parameters,
but there IS a limit to the data SIZE required by the parameters?
If so, what is that limit?
Kjell
--
--------------------------------------
Kjell Rilbe
DataDIA AB
E-post: kjell@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64