search

sipcapture / homer-app

HOMER 7.x Front-End and API Server
http://sipcapture.io
GNU Affero General Public License v3.0
205 stars 84 forks source link

Search call data by id #574

Open xuhualin99 opened 4 hours ago

xuhualin99 commented 4 hours ago

The following query is sent to the postgresql (seen from homer_app log) and its execution is taking a long time: select * from hep_proto_1_call where create_date between $1 and $2 and id in (1.08390982591e+11) limit 200 Strangely there is no index or primary key for the id field by default. After index added, the performance is still not getting better. It turns out that since its value is in scientific notation (e+11), postgresql thinks it's numeric type (not bigint) and the index is not used. We wonder where and how in homer_app this value is specified. Is it in the GUI or in the driver? This query is likely generated when user clicks on a specific sip message (after getting all messages by call-id for example). Is it possible to specify the value as integer, like 108390982591? Thanks

github-actions[bot] commented 4 hours ago

Your report is appreciated. Please star this repository to motivate its developers! :star: