How many insert queries in repeated function call #754
Unanswered
elhananjair
asked this question in
Q&A
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
Hello friends,
I am still testing postgresjs and it is so easy to work with thanks again @porsager.
The problem I am facing currently is, I am not sure if my insert query is really inserting all data that have been sent to the function I am doing insert with.
I have a function saveNum which saves/insert new phone number to database, and just for testing purpose I created counter variable to check if the counter and data from database is equal. But, unfortunately they are not. My question is, does PostgreSQL limits insert queries execute in certain amount of time? I am curious because I am inserting the data instantly as the process received external data which sometimes might be 1000 data per second that arrives from external server.
Therefore should I save such thing into array and run insert query in some time interval? or is there any tip for that? Here is the code I am working with [Implementing SMPP protocol]
I checked a database and deliveryCounter value and there is some difference.
Beta Was this translation helpful? Give feedback.
All reactions