Hello everyone,
Since I’m new to Endeca, i would like to ask some questions / advices for the experts that come to the forum.
I’m using version 3.1.
I have created a Graph where i add my columns (whenever i need to) and it is programmed to query the DB, do the transformations / joins necessary and pass it to a Bulk Add/Replace Records Component that inserts in the data domain (data store).
My questions are:
1- If i add a new column and i already have the data uploaded in the DD/DS, should i use the same graph with the new column in the metadata or should i create a new graph only containing the new column and use the Bulk Add/Replace Records (or other component) ? Which is the best and more pratical way to do this ? My graph is taking 1 hour (give or take) to update 3.5 M records, when i run it (and it raises linerly when i insert a new column)
2- Since my graph is taking a while to do the replaces, what can i do to improve the performance of such graph ?
Any idea of a component to use or advices regarding this subject ?
Regards and thanks for all the help!