Hi Rasmus, Indexes tend to be O(LogN), while RID is O(1). So it will always be faster.
Lvc@ ᐧ On 8 February 2015 at 11:39, Rasmus Eneman <[email protected]> wrote: > Luca, bu using slugs in your URLs instead of database IDs you completely > remove this problem, as well as making your urls nicer and better for SEO. > > A question for people with good experience with OrientDB, what is the > performance implications with using slugs over rids if the slugs are > indexed? > Should I take care to keep a slug to rid mapping in for example redis so > that queries to OrientDB always uses rids? > > > On Wednesday, January 28, 2015 at 12:43:21 AM UTC+1, JR wrote: >> >> Thanks Riccardo, >> >> good point! do you know how others are solving this problem? I'm planning >> to use OrientDB as my only storage solution. >> >> Thanks a lot, >> Luca >> >> On Tuesday, January 27, 2015 at 3:39:54 PM UTC-8, Riccardo Tasso wrote: >>> >>> Yes Luca, >>> >>> consider also if you use rids in your URLs. For example: >>> http://myapp.com/details.jsp?rid=1:1 >>> >>> In this case if someone links to your URLs it could be a problem. >>> >>> Cheers, >>> Riccardo >>> Il 27/gen/2015 21:29 "Luca Rondanini" <[email protected]> ha scritto: >>> >>>> Hi Andrey, >>>> >>>> just to double check, if I use RIDs in my web app everything should be >>>> fine. Inserts/updates won't change any RIDs. Problems may raise if, for >>>> example, I'm storing RIDs in MySQL as reference. If then, I export and >>>> reimport the data in orientDB the RIDs may be changed and the MySQL data >>>> won't reference the right rows anymore. >>>> >>>> Can you confirm? >>>> >>>> Thanks, >>>> Luca >>>> >>>> On Monday, January 19, 2015 at 5:28:16 AM UTC-8, Andrey Lomakin wrote: >>>>> >>>>> Hi Bertran, >>>>> The only issue is that if you do export database to JSON and then back >>>>> your RIDs will be changed. >>>>> But may be we will add option to keep rids on their places. Not so >>>>> hard to do. >>>>> The only downside of such flag will be presence of holes for rids of >>>>> removed records. >>>>> Each record removal consumes about 10 bytes of disk space (not so much >>>>> )) ), but when you do export/import we optimize space is used by database >>>>> as result rids may be changed. >>>>> >>>>> On Mon, Jan 19, 2015 at 2:48 PM, Bertrand Quenin <[email protected] >>>>> > wrote: >>>>> >>>>>> Hi, >>>>>> >>>>>> I'm currently using OrientDB for a project at work and I have some >>>>>> question about record IDs. >>>>>> >>>>>> As far as I understood, record IDs are unique and can be used to to >>>>>> identify a record in a deterministic way. I was wondering if these IDs >>>>>> can >>>>>> be used to identify objects through (REST) APIs. >>>>>> >>>>>> As any web application, I need to identify objects one way or another >>>>>> and I was wondering what the best approach would be: >>>>>> 1/ Using record IDs provided by orient DB >>>>>> 2/ Adding a "business" id field to my objects and manage it aside. >>>>>> >>>>>> So far, I didn't see any reason why I shouldn't use the record ID >>>>>> itself, the only con I see is that RID are strings clusterId#position >>>>>> (and >>>>>> not plain integers) and it's a bit harder to expose in an URL ... >>>>>> >>>>>> Is there any issue I haven't foresee ? >>>>>> >>>>>> Thanks for your help >>>>>> >>>>>> -- >>>>>> >>>>>> --- >>>>>> You received this message because you are subscribed to the Google >>>>>> Groups "OrientDB" group. >>>>>> To unsubscribe from this group and stop receiving emails from it, >>>>>> send an email to [email protected]. >>>>>> For more options, visit https://groups.google.com/d/optout. >>>>>> >>>>> >>>>> >>>>> >>>>> -- >>>>> Best regards, >>>>> Andrey Lomakin. >>>>> >>>>> -- >>>> >>>> --- >>>> You received this message because you are subscribed to the Google >>>> Groups "OrientDB" group. >>>> To unsubscribe from this group and stop receiving emails from it, send >>>> an email to [email protected]. >>>> For more options, visit https://groups.google.com/d/optout. >>>> >>> -- > > --- > You received this message because you are subscribed to the Google Groups > "OrientDB" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
