search

RedBeardLab / rediSQL

Redis module that provides a completely functional SQL database
https://redisql.com
Other
1.55k stars 150 forks source link

Is there a way to time a query? #40

Closed ba11b0y closed 5 years ago

ba11b0y commented 5 years ago

The redis logs give the time taken for the query execution but this time includes both the query translation of rediSQL and the actual database access time. Is there any way to just get the access time alone?

siscia commented 5 years ago

Hi,

At the moment there is not such interface.

What are you trying to achieve? Maybe there is a simpler way!

Cheers,

ba11b0y commented 5 years ago

I was trying to compare the time taken to execute a query between sqlite and rediSQL by performing the same query on the same data stored in sqlite and redis respectively. But since the SQL query is also translated while the query is performed, it surely adds to the total time. Is there any way I could obtain the actual time taken for the database access? Thanks.

siscia commented 5 years ago

I see!

No at the moment there is not such interface.

Indeed, RediSQL use SQLite under the hoo so the time performance should be roughly the same. There is of course some overhead in RediSQL but should barely be noticible for most use cases...

siscia commented 5 years ago

Please let me know if you got any further questions or of I should close the issue.