How do I optimize the VTS for use with multiple projects?
| ♥ 0 |
We have five different project that need to use the VTS concurrently. What can I do to optimize efficiency and handle multiple projects?
Marked as spam
|
Posted by |
Private answer
This is the way that I have handled this in the past. I assign a Column name in the VTS to each project. Then I create a composite record that contains multiple data elements separated by a delimiter (For example a '':''). Example Composite data: 234398:Smith:John:11987 Cathy Rd:Lithia:FL:33547:813 555-5555:221-89-9999: Once this is done, you make a single retrieve from the VTS on the project column. Within your script, use strtok to separate the data elements and place those in parameters using lr_save_string. As far as I know there is no limited on the number of characters stored within a single VTS data field. Marked as spam
 Posted by garystew (Questions: 4, Answers: 41) Answered on February 7, 2014 6:47 pm
|