Skip to main content
A
Anonymous
January 31, 2018
Question

Number of row from stream between two date

  • January 31, 2018
  • 5 replies
  • 3615 views

Hi All,

I need a service that return the number of row contained into stream between two date (StartDate and EndDate).

The service must  return only the number of rows.

If that does not exist is it possibile to create it ? How ?

Mnay Thanks

BR

Dimitri

5 replies

C
CarlesColl1-Visitor
1-Visitor
January 31, 2018

It doesn't exists actually, you have to query it, and just get result.rows.length

A
Anonymous
January 31, 2018

Hi Carles,

I know the service like QueryStreamEntries or QueryStreamData but they need more time to returned this value. They need 32 sec to return a value of 249567 row.

Is it  possible to create a new service ?

BR

Dimitri

C
CarlesColl1-Visitor
1-Visitor
January 31, 2018

When you mean a new Service, what does you mean?

I mean, you can create a custom service that does the QueryStreamEntries and result.rows.length and just return the value, but yes for 300k Rows it will be super slow.

I suppose that you mean creating a service that access the database directly and does the select count(*) where query_condition --> Short answer, not out of the box, long answer, yes you can connect directly to the PostgresSQL database ( if you are on this bdd storage ) and look on internal database structure to do the job.

Terms & ConditionsAccessibility statement