Enrico Risa comments

Results 229 comments of


                                            Enrico Risa

Query has different outputs in studio and orientjs db.query

hi @EricLin2004 yes drop me an email i will look at it tomorrow

Query has different outputs in studio and orientjs db.query

hi @shyamchandranmec which api are you using to query? the query builder or raw query?

Query has different outputs in studio and orientjs db.query

Try this should work with fetchplan ``` JAVASCRIPT db.query('select *, $author as author from Comment let $author = (select name,@rid from User where out(WROTE_COMMENT).@rid in $parent.current.@rid ) where in(HAS_COMMENT) in...

Query has different outputs in studio and orientjs db.query

hi @shyamchandranmec did you try the solution with fetchPlan?

Query has different outputs in studio and orientjs db.query

hi @shyamchandranmec did you try it?

Query has different outputs in studio and orientjs db.query

hi @shyamchandranmec Any updates?

Best practice to handle lots of connection to multiple databases

hi @StarpTech with `new ODatabase({ name: , ... })` you should open and close every time the socket. That could be not efficient. You could leave the db open but...

Best practice to handle lots of connection to multiple databases

hi @StarpTech that would work, but if you have a lot of tenant you will open too many connections 5 for each tenant.

Best practice to handle lots of connection to multiple databases

hi @StarpTech yes i think the best way is you have a pool for all tenants. But OrientDB.Pool you cannot now. Let me think about it for handling a lot...

Best practice to handle lots of connection to multiple databases

hi @StarpTech it means that the pool is binded to one databases. You could create a pool for each database Let me check if i we can use some solution...