Posts by Rodrigo Mendes • 11 points
4 posts
-
0
votes0
answers76
viewsQ: Mysql - What is the best input to be created in this case
Hello, I have a table in the database with the product price history. This table is very voluminous having more than 1 billion records. How can I create an index in this table, to meet the query…
-
0
votes0
answers361
viewsQ: PHP Mysql connection performance on remote server
I am at all costs trying to improve the loading time of my pages, however I am suffering with a bottleneck. The connection between the web server(godaddy) and my database server(local with dedicated…
-
0
votes1
answer520
viewsQ: Time difference in execution of the same query between PHP and PHPMYADMIN
I am trying to improve the performance of my pages to improve the user experience, but, I am not able to identify the problem. According to Google, it is recommended that the pages respond in less…
-
1
votes2
answers213
viewsA: Erase everything except the smallest one per day
I suggest you do the following. Create a table to assist processing with select below select produto, date(datetime), min(preco) from tabela group by produto, date(datetime) This way you will have…