Page flow make my mysql server get up to 50-70 selects per second

Hi I put a page flow in my webpage that should update the webpage from my MySql DB and just seconds after I hit save button and the page was downloaded to the server the MySql server whent to the roof. I have no Auto run on this and I didnt even start the web page on the browser.
But when I closed it on wappler it was OK
Then reopend it on wappler it was quit until I made some changes on the webpage then it started again.
Toggle off appconnect stopt it and it did not start again.
Toggle on appconnect again it did not start until I maked a change on the webpage

Do not have to save it. Bug ??? I think there is somthing wrong with appconnect and page flow.

Can you run the devtools in your web browser (F12 in firefox and chrome)?
Look at what it’s sending (request) and what the server is sending back (response).
Make sure that you are on the Network tab, have XHR selected below that, and you can select whatever action is happening on the page and see the request and response.

Showing your code on here may help too.

I find if I have to show something I look at it very carefully, and at least half the time I go “aaaahhh… :exploding_head: … I’ve done something silly here!”.

The other half of the times someone else looks at the code and tells me what I’ve done wrong!

The problem her is that the problem occurs only in wappler developer view not in the webbrowser. There it works perfect.
And it only happens when App connect is active.

Does it happen while you are editing the page? Depending on the things you edit the design view reloads the content to display the changes, this would also trigger the flow at that moment.

Do you have a local development server setup where you work on? You should not be working directly with the production target.

Will see if we could perhaps implement some caching for the design view to prevent many calls to the actual server, but you should mainly work with a local development server when editing.

Hi, this problems accurs when I change the webpage in designer and when app connect is on.
when app connect is not on it would not do it.
But if I have app connect on and then changes anything on the webpage the flow is starting and is not stopping executing until I put appconnect to off. If I then turn it on the flow is not executing before I change the page again.

Shouldn’t the flow just fire once even with appconnect on. This is a normal flow updating 2 sql that is just a small select sentence. But the flow is running endlessly. And my test mysql server is going to the roof. Get about 60-70 select hits per second. just by that connection.

The flow should load once when the page is loaded. As I said, when you edit the page depending on the edit it will reload it again to update the design view, this will trigger the flow again. We try to do only partial update in the design view, that would not trigger a reload, but when the head of a page is edited or new includes are added it requires the reload. Also when typing directly in codeview often triggers a reload of the design view (it has a debounce, so it should only update when you stop typing).

Aha point taken :slight_smile: