Looking for a sqlite query to update a table with a size of 80k records and 70 column each. The query need to update 7 fields in each record by fetching content from the other table. The SQlite database is in memory database and the query should execute fast. The current solution is taking 63 sec. However the creation of the same table is taking only 4 sec. looking for similar performance for update as well.
Hello. It may not be possible to make UPDATE work as fast as populating the table with initial data but still let me take a look. There are a few ways to make UPDATE a little faster. I can help you with it right now.
have already done this kind of task many times almost daily can do in one day if proper requirement get,not a big task just explain exactly what u want
I have more than 10 years of experience with optimizing SQL queries on various RDBMS. Although, it is hard to see whether a query can be optimized without seeing the query itself. Would you mind to attach it to your project?