This post is more than 5 years old
5 Posts
0
2423
Problem of performance with xam query
Hi all,
When i execute the query below, in order to get only one record.
I wait 8 minutes to have the response. is it normal?
String query = "SELECT \".xset.xuid\" WHERE \"filename\" like 'doc1.pdf'";
my environment is :
1) os client = windows xp pro
2) VIM = centera_vim
3) jvm = java 6
regards,
Diabate
gstuartemc
417 Posts
0
February 4th, 2010 02:00
You must remember that the Centera XAM implementation does not function like a database - it is intended as a disaster recivery tool. To understand the performance implications you must consider how the Query is performed on the cluster.
As you are querying on a piece of metadata, the cluster must internally open all XSets on the cluster that you have read / query permission on, and check for the existence (and value) of the search term you supplied. The matches are then returned in the result set.
This is a very intensive operation - if you remove the metadata search element and simpky retrieve all XSets over a time range you will see that results are returned quite quickly.
Query should never be used as a "general purpose" database replacement in situations where you are only looking for a very small number of XSets out of the total number you have access to and you require the results quickly. It should be used in conjunction with your local information repository.