Query in multiple databases

[Thomas Flemming]

Hi Ruslan,

thanks for your quick response.

>> I like to know, if there is some features in Valentina to easily access tables
>> across multiple databases.
> 
> No way currently.
>  
>> I have to deal with gigs of data, which is divided into 20-30 different
>> databases. All databases have the same structure.
>>
>> So when I do a query in a specific table, I would like the engine to look in
>> all databases in this table.
>>
>> Is this somehow possible?
>>
>> I know, I can do a select with union, but maybe there is something more
>> elegant with the api?
>>
>> btw: all data-access is readonly in my case.
> 
> Not so far, one developer have told me, they also have 255 dbs,
> With the same single table, but they have own hash-function which convert
> Key of a record to an index of db.
> 
> But that is read/write of some db.
> 
> 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...

Ok, I will write my own.

Best regards,
Tom





-- 
/****************************************
**   Dipl.-Ing. Thomas Flemming
**   Software Development
**
**   Touratech AG
**   Auf dem Zimmermann 7-9
**   D-78078 Niedereschach
**
**   mail  tf at ttqv.com
**   fon   +49 (0) 7728 9279-206
**   fax   +49 (0) 7728 9279-29
**
**   http://www.ttqv.com
**   http://www.touratech.de
**
**   ... und immer dem Pfeil nach!
***************************************/