Amouny of query's to database per minute or seconds.

Hi evryone.

I whas wondering if aomeone knows how manny query’s can be done evry minute.

Lets says i have 10.000 people online and they all query and insert something at the same time…
Will thia work?
If not, are there any work arounds?

Kind regards,
Kristof.

I will have to look into this, but I want to make sure I understand your use case.

You expect to have 10k people online simultaneously hitting a query that needs to run fresh each time because each user will be inserting? Can you explain a little more about the use case? Is this a one time event that you expect a surge?

Hi Amanda,

I whas a big fan of text based incremental browser games in the early 2000’s.

A game like that is called ogame developed by gamegorge.

I was wondering if it would be possible to make it using a wix website.

People have resources and buildings.
Evry second or minute evryone gets their resources depending on their building level.

I gues it would be possible if i did it evry hour using a schedule task, the u could uae a bulk query wich is just 1 query i guess?

Hope this makes thinga clearer?

Kind regards,
Kristof.

@volkaertskristof Ha! I am in the process of working out the logic for an old mud style game now, would love to see your game when it is done.

As far as query limits, I need to ask around a bit on that question so I will get back to you when I know or have someone else with more knowledge on that particular subject respond here.

Thanks , i will hear it then when you or someone else knows more :wink:

Its will be a long process to make it but i will share it when its done.

I have some source files from OGame, but there whas a game i liked to play wich i sadly enough can’t find anything from .

My other game i liked to play is shimlar. (It still exist) but not many people play it anymore.

So i’m not sure what to make yet.

I do have 1 more question.
Is there a way to save data to a database if someone just closes the browser?
Lets say i use a dataset,
When soneone logs in it gets their data,
They do stuff and gey more money/resources but it does not save to the collection yet.
Then wheb they log off or cloae their browser (any way possible) it saves their data.

Is that possible?

So, for your data question. One of our technical writers released an article just yesterday about data quotas. Take a look and let me know if this is enough information for you, if not I will reach out to them for more specifics.

About Data Quotas

For your second question, you could potentially do an auto-save feature on an interval like some games do which would only lose a little of their level if they forget to save.

I also know that in JS you can detect the attempt on the user to close the browser or navigate away to prompt them to save. I have never attempted this in WiX/Velo though. My guess is you would need to add this in the scripts in the dashboard perhaps?

Hi @amandam
Thats exactly what i needed to know.
Seems like i could start using wix collection and maybe in the feature i can use an external database if needed :slight_smile:

The best part so far is this 1:
The following API functions count as 1 request towards the write quota:

  • bulkInsert
    If using bulk insert only uses 1 request then i think i’m good to go. :smiley:
    Still figuring out what i should do.
    Start with an old OGame alike game.
    Or start a game like shimlar with sort of a map you can walk around in :stuck_out_tongue:

Map might be a nice tought but probably a bit harder to code😅