Query in multiple databases

[Ruslan Zasukhin]

On 5/26/09 12:39 PM, "Matthew Jew" <mjew at icnc.com> wrote:

>>>> For search I think you self can start N search against of N dbs.
>>>> May be in N threads to use more CPUs of computer.
>>>> Results combine into new tmp table. RAM or disk...
>>> 
>>> I thought access to Valentina engine was limited to one thread at a
>>> time. (As of version 2.5.8)
>>> 
>>> Previously, I had asked this:
>>> 
>>>>> I asked if I still need to lock the entire engine, and I was hoping
>>>>> for either "yes" or "no".
>>>> 
>>>> Currently the answer is - Yes.
>>> 
>>> Has this changed?
>>> 
>>> If so, what are the rules now?
>> 
>> Rules the same...
>> Really, Cache will be single, so your app should use mutex.
>> 
> 
> If the rules are the same (meaning only one thread at a time),
> how can he start "N search against N dbs. May be in N threads to use
> more CPUs of computer."
> as you recommended to him?

Sounds like no way for single process.

Interesting...if we could to have N caches
    one for each db then this could work ...


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]