Moralis server delay hours when updating transaction to Database

I want to listen to new comming BSC transactions,
I have also followed the instruction of Moralis:

  Moralis.start({
        serverUrl: 'xxxxxxx',
        appId: 'xxxxxx',
  });

  const query = new Moralis.Query("BscTransactions");
  query.equalTo("to_address", '0xxxxxxxxxxxxxxxxx');
  const subscription = await query.subscribe();

  subscription.on("create", function (data) {
        console.log(data.attributes);
  });

but results are not expected, for example:

{
block_timestamp: 2021-12-08T07:33:06.000Z,
hash: ‘0xbe3750f9279f4f8d77140d10997b4e0d96294ec2b55fadfb285622fd09962718’,
nonce: 3279,
block_hash: ‘0x8499b081bb78b4ee68a512f11d7f4d16d04e8607148ca44e807e5e2998e06927’,
block_number: 13292197,
transaction_index: 421,
from_address: ‘0x8b4894e04251d0bcb434fd078760b763f25bac57’,
to_address: ‘0x10ed43c718714eb63d5aa57b78b54704e256024e’,
value: ‘0’,
gas_price: 5000000000,
gas: 208408,
input: ‘0x38ed1739’,
confirmed: false,
createdAt: 2021-12-08T07:51:50.618Z,
updatedAt: 2021-12-08T07:51:50.618Z
}

block_timestamp: 2021-12-08 07:33:06
but
createdAt: 2021-12-08 07:51:50

=> 20 minutes delays

:smirk: :confounded: :persevere:

It can be a delay if your server is too overloaded and it can not keep up with all the transactions. How is that delay now?

its still too lag, 21 minutes delays at this time ! :worried:

what do you have there in particular? a watch on a specific address on bsc?
I see that you only have less than 5k transactions in that table, so the load shouldn’t be the problem

I do nothing special, just filter by to_address, but server seem overloaded (CPU 77%)

it looks like there is some CPU usage there, can you paste that address that you watch to see how many transactions it has? and also, because it is syncing historical data, it could take some time until it is up to date

I have recreated new server without historical data check, but result does not changed !

now it looks like it is close to 10 minutes delay, maybe the server can not handle the load, how many transactions has that particular address per minute?

now it looks like it is close to 10 minutes delay, maybe the server can not handle the load, how many transactions has that particular address per minute?