|Subject||Re: [firebird-support] Re: commit after insert is very slow|
> the table have more than 10 000 000 records (actually many more)Curiosity: what kind of area has more than 10 000 000 houses? What
> now we need to retrieve any kind of subset in any of the previous available order by, and this in lower than 100 ms !
will happen at 101st millisecond? They will burn?
IMHO - you should think about partitioning.