Ruslan Posted February 24, 2019 Share Posted February 24, 2019 Hello, ug1486 I have such form: After I click row in upper grid in OnAfterScroll event of UniQuery I do Close and Open query for bottom grid. It query work for 1-2 seconds (all my operation finished in 1-2 second) but after that bottom grid "Loading..." for 10+ seconds... 5-6 rows. I can't understand what it do all this time. There is no any Ajax or Delphi events both on the bottom grid and dataset of this grid. Where to look for the problem? EXE-file, DB on the local server, open using localhost:8077, icore7, 16Gb memory, Chrome. Quote Link to comment Share on other sites More sharing options...
Ruslan Posted February 24, 2019 Author Share Posted February 24, 2019 I added "showmessge" on exit from my function which load data to bottom grid - after that I see "Loading..." for 5-10 seconds... Quote Link to comment Share on other sites More sharing options...
Ruslan Posted February 24, 2019 Author Share Posted February 24, 2019 this is when "Loading" it start after ShowMessage dialog displayed, only 5 rows returned by query Quote Link to comment Share on other sites More sharing options...
Ruslan Posted February 24, 2019 Author Share Posted February 24, 2019 I have tried ISAPI on IIS but can't run application - it is download DLL instead run. All did as described here http://www.unigui.com/doc/online_help/iis_7_0.htm Quote Link to comment Share on other sites More sharing options...
Ruslan Posted February 25, 2019 Author Share Posted February 25, 2019 It is important, my work for last 2 month haven't sence if bottom grid will display for 5-10 seconds after dataset got data from DB ) Quote Link to comment Share on other sites More sharing options...
Ruslan Posted February 25, 2019 Author Share Posted February 25, 2019 Problem was due to small timer interval which sent hundreds requests to server per second, and SQL query which very slow in prod environment but acceptable on dev. Quote Link to comment Share on other sites More sharing options...
zilav Posted February 25, 2019 Share Posted February 25, 2019 Ну так залогируй на сервере время открытия датасетов, и посмотри разницу между дев и продакшеном. Если разница реально присутствует то унигуи тут совершенно не причем. Возможно стоит перейти с переоткрытия дочернего датасета на фильтрацию. То что унигуи постоянно отправляет мелкие запросы на сервер давно известно, кстати, если продакшен сильно далеко да еще и на более слабом сервере это тоже может являться проблемой. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.