每一天,我们的服务(后端使用.Net和MySql数据库)都插入、更新和删除数十万个项目。
现在,我们正利用他们的再生API将服务与其它服务整合。 每次在服务上插入、更新或删除某个项目时,我们也需要连接到他们的网络服务,并使用 POST、PUT、DELETE。
此案有什么好的执行?
每次用户在我们的服务上插入一个项目时,似乎不宜与它们的API连接,因为对于用户来说,这将是相当缓慢的经验。
另一个想法是像往常一样更新我们的数据库。 然后设置另一个服务器常数连接到我们的数据库, 并获取需要张贴到 RESTful API 的数据 。 这是前进的道路吗?
任何执行这种事情的指南都行,谢谢!
It depends if you delay in updating the other service is acceptable or not. If not, than create a event and put this in queue of event processor who can send this to second service. If delay is acceptable than there can be background batch job that can run periodically and send the data.
I noticed that there were some threads with similar questions, and I did look through them but did not really get a convincing answer. Here s my question: The subquery below returns a Table with 3 ...
<?php $con=mysql_connect("localhost","mts","mts"); if(!con) { die( unable to connect . mysql_error()); } mysql_select_db("mts",$con); /* date_default_timezone_set ("Asia/Calcutta"); $date = ...
我把我的用心从使用QQL转向MySQL。 它与凯科特合作,现在不工作,因为我已经改变,使用MySQL。 这里的错误信息是:
We have a restaurant table that has lat-long data for each row. We need to write a query that performs a search to find all restaurants within the provided radius e.g. 1 mile, 5 miles etc. We have ...
Is it possible in php to return a specific row of data from a mysql query? None of the fetch statements that I ve found return a 2 dimensional array to access specific rows. I want to be able to ...
Our website was developed with a meta tag set to... <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> This works fine for M-dashes and special quotes, etc. However, I ...
What are some of the strategies being used for pagination of data sets that involve complex queries? count(*) takes ~1.5 sec so we don t want to hit the DB for every page view. Currently there are ~...
My table looks like person_id | car_id | miles ------------------------------ 1 | 1 | 100 1 | 2 | 200 2 | 3 | 1000 2 | 4 | 500 I need to ...
