Are you sure about those numbers? The client side timestamp is made using the clock on the client, and might differ if it is out of sync with the server.
In any event, if it takes a long time, my guess is that your search return a lot of records. How many records does you search return?
Advanced Search: ('536870917' = "NRW" AND '536870928' = "Aachen")
If it returns a lot of records (maybe 500+), the only your is to redesign the solution. Mabe by choosing one tier at a time from a set of fields for each level in your tree.
Best Regards - Misi, RRR AB, http://rrr.se
you should think about using the max row settings.
Enter the maximum number of records that can be returned by a search.
The default is 0, which means that the number of records is unlimited unless the Limit Number of Items Returned user preference is selected.
NOTE Because users can override the Max Rows setting by selecting Refresh All in BMC Remedy User, also use an appropriate qualification to control the amount of data that can be returned by a search (see step f).
Alternatively, use chunking to return all records while limiting the number of records displayed at one time. If you enable chunking, this setting is ignored. See the Size of Chunk property in this table.
- (List view, tree view, cell-based, alert list only) To limit the data that appears in the table, click the ellipsis button to the right of the Qualification field, and use the Expression Editor to create a qualification statement.
You can use fields from the current form or from the data source form. You can also use keywords. The way qualifications function in table fields is similar to the way that they are used with the Set Fields action.
The character limit for strings in a qualification is 4K.
For more information, see the Workflow Objects Guide, "Building qualifications and expressions," page 49.
Alternately, if using a table field you can limit the number of records returned in the table into "chunks" which you can move forward and backwards through.
A couple of things to look at.