Re: [Firebird-net-provider] big problem

[<car...@te...>]

Hello:

> this happend under havy load :( i have aprox. 40000 articles in 
> database.. and im creating list of words for seraching. It means get 
> article from database, split it in words array and foreach word look if 
> it is in database if not insert it... i use one connection and one 
> transaction for all word looking and inserting and separate connection 
> and transaction for geting article...

Ok,  i have made tests inserting 100 000 in 4 tables without problems, 
are you using Fb 1.0 or Fb 1.5 ??

> If you will want i will send you my code..

If you can send a test case it can be helpfull.




Best regards
Carlos Guzmán Álvarez
Vigo-Spain