I have a request to get data in my mySQL database (36,848 entries). Then I format and append them with jQuery on my web page. These two operations take 2 minutes and 30 seconds. During this time, no other operation is possible on the page. Is there a way to optimize this to speed up the process? Like this, it’s
Tag: request
SQL – request to find the average loans by user
I am struggling with a SQL request. I need to find a request to calculate the average loans per user. I was thinking in doing a LEFT OUTER JOIN between the table SUSCRIBER and the table Loan in order …
PostgreSQL DETECT age’s groups
Let’s consider a part of table like this: id_client | age ———–+—– 16052 | 65 25027 | 29 25659 | 44 33297 | 32 38750 | 53 43063 | 28 56311 | 48 …
SQLSTATE[01000]: Warning: 1265 Data truncated for column
SQLSTATE[01000]: Warning: 1265 Data truncated for column ‘pay_totals’ at row 1 public function order(Request $req){ $order = new Order; $order->pay_number = $req->…