I need to develope an access DB with connected table related to 1-1 new field table.
The connected table is keeped through a datawarehouse Application based on Pervasive.
The problem is that i have to perform a query on a Pervasive table which has 40000 records, from which i have to extract only actual warehouse article present.
The query which has to be executed is too long to be performed and often access seems to hang up.
The question is : is it right this long elaboration time?
The connected table is keeped through a datawarehouse Application based on Pervasive.
The problem is that i have to perform a query on a Pervasive table which has 40000 records, from which i have to extract only actual warehouse article present.
The query which has to be executed is too long to be performed and often access seems to hang up.
The question is : is it right this long elaboration time?
