On Wed, Mar 28, 2012 at 2:04 PM, nathanelrick <nathanelrick@...> wrote:

>
>
> yes i understand, but now with my 50 millions rows table i start to meet
> the limit of firebird where a simple prepare can take around 1 s to 1 min
> dependantly the charge of the server (see my previous post). next year it's
> will be around 100 millions rows and i will have no solutions ... this why
> i start to thing about sharding in an easy way, in a way out in fact
>

Fair comment. I think Firebird 3 should handle preparing queries on large
tables better. And with luck, it will be available in your timeframe.

Good luck,

Ann


[Non-text portions of this message have been removed]