Hi Luca, the database isn't on the same server as the web server, and will never be, so unfortunately I'm afraid I can't use plocal mode.
And Enrul, I guess indeed I will have to look at server-side function. But that still implies a somewhat tedious re-write of my application, since currently my logic is with my Java code and I'm interacting with OrientVertex/OrientEdge object and making multiple calls in separate modules (each module is responsible for a specific type of entity for increased code coherence). Now I'd have to rewrite the logic in Javascript and reconsider my current architecture. I'm gonna have to rewrite whether it's server-side functions or if I switch to a different database, though. I'm just curious as to why it's taking so long to perform single-record fetching based on a unique key, possibly the most fundamental operation a database should be expected to perform quickly. Best regards, Jean On Monday, May 2, 2016 at 7:11:26 PM UTC+8, l.garulli wrote: > > Jean, > WDYT about connecting to OrientDB in plocal mode? > > Best Regards, > > Luca Garulli > Founder & CEO > OrientDB <http://orientdb.com/> > > > On 2 May 2016 at 12:14, Emrul Islam <em...@emrul.com <javascript:>> wrote: > >> Have you looked at using server-side functions: >> >> http://orientdb.com/docs/last/Functions.html >> >> you can write them in Java and they execute within the OrientDb server. >> >> Also consider using hooks (even more performant) : >> http://orientdb.com/docs/last/Java-Hooks.html >> >> >> >> On Monday, May 2, 2016 at 8:08:51 AM UTC+1, Jean-Sebastien Lemay wrote: >>> >>> If client-side filtering is the issue, then I have another problem. I'll >>> need to rewrite my entire back-end, and a lot of my operations have a lot >>> of conditions, which makes it almost impossible. >>> >>> For example, consider this operation: a user connects to a channel. >>> 1) Register a new connection edge between user and channel >>> 2) If number of connections between user and channel jumped from 0 to 1, >>> user is now part of channel. If so, create an active user edge between user >>> and channel as well. >>> 3) If user became an active user and user is a moderator of the channel, >>> the channel is now considered live (channel vertex update) >>> etc. >>> >>> A lot of 'IFs' which are better suited to Java code than SQL code. >>> >>> What would you suggest for this situation? >>> >>> Best regards, >>> Jean >>> >>> >>> >>> On Monday, May 2, 2016 at 2:40:12 PM UTC+8, l.garulli wrote: >>>> >>>> Are you using remote protocol, right? In this case all your filtering >>>> is happening at client side paying a lot in terms of latency. >>>> >>>> WDYT about executing a query/command that do all your job at server >>>> side? >>>> >>>> Start with this query executed in graph.command( new >>>> OCommandSQL("<query>") ); >>>> >>>> SELECT friendship.confirmed, inV( friendship ) FROM >>>> SELECT out('social').outE('friend') as friendship FROM Account WHERE >>>> uuid = 'blablablablablablablablabla' >>>> ) >>>> >>>> >>>> Best Regards, >>>> >>>> Luca Garulli >>>> Founder & CEO >>>> OrientDB <http://orientdb.com/> >>>> >>>> >>>> On 30 April 2016 at 21:43, 'scott molinari' via OrientDB < >>>> orient-...@googlegroups.com> wrote: >>>> >>>>> Ok. Sounds like you are right about the profiles. I hope the ODB guys >>>>> can help. I think I pulled enough of the right information out of you, so >>>>> they can help. Sorry, I am not more help. >>>>> >>>>> Scott >>>>> >>>>> -- >>>>> >>>>> --- >>>>> 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 orient-databa...@googlegroups.com. >>>>> 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 orient-databa...@googlegroups.com <javascript:>. >> 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 orient-database+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
