Hi Alexander
Do you need to Expand ?
select expand(in('Manages')) from asset where guid =
'19da4856-57c0-4b39-8f4b-53fc47f86dcf')
Returns a result set of the complete records, which you don't seem to need,
just the rid.
select in('Manages') from asset where guid =
yes it is faster, but it gets in a weird state. If i remove the inner
select and just run this
update Agent set lastCommunicationTime=date() where @rid = #13:3
it's taking 2 seconds.
On Friday, February 6, 2015 at 9:42:19 AM UTC-6, syshex wrote:
Hi,
Without the expand it should be faster
Ok, i see what happened
if i run this in the sql analyzer it i don't see a rid
select in('Manages').@rid from
asset where guid = '19da4856-57c0-4b39-8f4b-53fc47f86dcf'
but if i run this new
update Agent set lastCommunicationTime=date() where @rid in (select
in('Manages').@rid from
asset
Hi,
Without the expand it should be faster now.
The hanging bit, are you saying that after running update commands like
that , after a bit the server starts hanging and/or the queries taking
longer to execute ?
Anything being printed on the logs ?
On Friday, February 6, 2015 at 3:25:26 PM
Try this:
update (select expand(in('Manages')) from asset where guid =
'817ea932-4a4a-49a4-8454-37c5098703a2') set lastCommunicationTime=date()
With expand the collection becomes the resultset.
Lvc@
On 6 February 2015 at 17:40, alexander anguiano jobl...@gmail.com wrote:
I didn't realize
Have you thought to do change in this way:
update #13:3 set lastCommunicationTime=date()
bye
Emanuel
On 06/02/15 15:59, syshex wrote:
update Agent set lastCommunicationTime=date() where @rid = #13:3
--
---
You received this message because you are subscribed to the Google Groups