The below query finds one id by using the below query format but it seems I have indexed all columns, but it took time to execute between 54.3 seconds - 1.2 mins. What can I try next? Query: select op.ord_prod_id…
I am doing autocomplete query system for cities and I have problem, that I want to prioritize main city of region from another results showed for exact phrase for ex. "%Trenc%". |id| city | region | ... |12 | Trenc…
I have a table with close to a billion records, and need to query it with HAVING. It's very slow (about 15 minutes on decent hardware). How to speed it up? SELECT ((mean - 3.0E-4)/(stddev/sqrt(N))) as t, ttest.strategyid, mean, stddev,…
I have that kinda table and data : Table Name : data +------+-----------------+--------+----------+ | id | number | name | surname | +------+-----------------+--------+----------+ | 1 | [1, 2, 3, 4, 5] | John | Doe | | 2 | [1,…
I'm kinda new to programming in general. I'm trying to loop through a table. There is a connection to the DB already. It's giving me - "Object of class IlluminateDatabaseMySqlConnection could not be converted to string" class ProductController extends Controller…
I am making a site in which user uploads it's pdf and back of the site we generate audio file for each page and now we want to save it on the database(mysql). Now the problem starts we have model…
Requirements: Before, I used instr() in Oracle to achieve the requirements, but now I want to use MySQL to achieve the same effect, and try to use the functions in MySQL to achieve it. INSTR(A.SOME_THING.B,".",1,2)<>0 --ORACLE
I have a query which is supposed to retrieve data from mysql and print it on the browser. It is working with a few rows of data but when the data gets bigger it just stops working and doesn't give…
I need to make basically this without using the "Group by" SELECT idEmploye , COUNT(*) AS nbrProjet FROM ressourcesprojet_ GROUP BY idEmploye HAVING COUNT(*) > 1; My Database code for creating it : https://sourceb.in/JePvGUccpU Things i tried : SELECT e.idEtape,…
I want to calculate the difference between endTime and startTime for their corresponding IDs and display ID and duration(calculated field) without having to create a new table in SQL. I have tried ordering the table and using LAG and LEAD…