SQlite update query

$10-30 USD

Closed

Posted

over 5 years ago

$10-30 USD

Paid on delivery

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.

Python

SQLite

Project ID: 18414697

About the project

9 proposals

Remote project

Active 5 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

9 freelancers are bidding on average $44 USD for this job

@leemilun

hi employer. i am a expert in python and sqllite. so if you award me this project, i will complete it in time. please reply me kindly. thanks.

$55 USD in 1 day

4.7

(43 reviews)

6.4

@naryl

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.

$30 USD in 1 day

4.9

(34 reviews)

5.5

@JawadIT

Hello. SQlite expert here since 4 years. I have optimized around 200+ queries with quick results. You may contact for further.

$100 USD in 1 day

5.0

(6 reviews)

2.5

@coder9600

Hello, Kindly send me a message in order to discuss more details about your project and its requirements. Thank you!

$25 USD in 1 day

5.0

(3 reviews)

1.8

@iqvalsingh28

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

$25 USD in 1 day

0.0

(0 reviews)

0.0

@kurbsky

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?

$15 USD in 3 days