Book a Demo

Author Topic: Repository.GetElementById vs GetElementByGUID  (Read 6354 times)

Ondrej Kolenaty

  • EA User
  • **
  • Posts: 23
  • Karma: +0/-0
    • View Profile
Repository.GetElementById vs GetElementByGUID
« on: April 27, 2008, 11:59:11 pm »
Hi,

  does anyony know whether there is any speed diference, if any, between Repository.GetElementById and Repository.GetElementByGUID functions?
 I am making quite complicated transformation, with usage of addin functions, and I would like to improve the performance.

Thx.

thomas.kilian

  • Guest
Re: Repository.GetElementById vs GetElementByGUID
« Reply #1 on: April 28, 2008, 06:05:53 pm »
Look into the DB and see whether both (I guess) or only one of them (unlikely) has an index.

Ondrej Kolenaty

  • EA User
  • **
  • Posts: 23
  • Karma: +0/-0
    • View Profile
Re: Repository.GetElementById vs GetElementByGUID
« Reply #2 on: April 28, 2008, 09:02:35 pm »
Both columns in database has an index. Still the practise can show a difference.

thomas.kilian

  • Guest
Re: Repository.GetElementById vs GetElementByGUID
« Reply #3 on: April 29, 2008, 01:18:10 am »
It could. But I guess EA is quite simple in that respect. Just a guess, but likely not too wrong. To my experience any GetBy is mapped to an according SQL. So the DB will make the difference.