Sure, it is always the 35 seconds. Each time
{
"result": [
{
"@type": "d",
"@rid": "#12:551464",
"@version": 2,
"@class": "Abstract",
"appln_abstract": "Device for connecting a network of pipes
located in a roadway to a distribution conduit, comprising an assembly of a
container with upright walls and a cover fitting thereon, provided with at
least two openings through which an outer end of a pipe of the pipe network
can be fed in each case in order to connect this outer end to a
distribution pipe which can be received in the container, wherein for each
distribution pipe at least one distribution opening is arranged in the
assembly which can be connected to the outer end of the distribution pipe,
wherein the recesses are arranged at the position of the connection between
the upright walls and the cover. <??>Arranging of the recesses at the
position of the connection between the upright walls and the cover ensures
that the pipe ends can be readily guided into the container, since
sufficient clearance is possible. When a pipe end protrudes for instance
slightly obliquely through the opening, there is sufficient clearance to
realize the connection to the distribution pipe. <IMAGE>"
}
],
"notification": "Query executed in 39.006 sec. Returned 1 record(s)"
}
Btw I did not test this without an indexing, but surely that would last
years :D
Am Montag, 18. August 2014 17:23:40 UTC+2 schrieb Enrico Risa:
>
> Hi Curtis
>
> can you post the result of
>
> explain select * from Abstract where appln_abstract LIKE "%of a pipe of
> the pipe%"
>
> Thanks
> Enrico
>
>
> 2014-08-18 17:19 GMT+02:00 'Curtis Mosters' via OrientDB <
> [email protected] <javascript:>>:
>
>> I'm still testing around with OrientDB. Today I realized that OrientDB is
>> 3 times slower on the same data, with the same indexer compared to MySQL.
>> How can that be?
>>
>> So there are ~250k entries. FULLTEXT indexer are used on both db's. (from
>> https://github.com/orientechnologies/orientdb/wiki/Indexes)
>>
>> And the test query is:
>> select * from Abstract where appln_abstract LIKE "%of a pipe of the
>> pipe%"
>>
>> in OrientDB: 34 sec
>> in MySQL: 14 sec
>>
>> I tested this on them both 3 times and this is the average.
>>
>> Any ideas?
>>
>> --
>>
>> ---
>> 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] <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 [email protected].
For more options, visit https://groups.google.com/d/optout.
