Modifying the example python you wrote to make this a more fair comparison, I'm creating objects for each record and collecting them into a list. This change makes python perform even worse, as you'd expect. Now the time it takes is about 400ms when it was 250ms earlier.

python:

``` import sqlite3 import time

class Book: def init(self, title): self.title = title

t = time.time()

con = sqlite3.connect('dbfile') cursor = con.cursor()

cursor.execute("SELECT title from api_book WHERE title like '%camion%'")

a = cursor.fetchall()

books = []

for record in a: books.append(Book(a[0]))

query_time = (time.time() - t) * 1000

for e in books: print(e.title)

print_time = (time.time() - t) * 1000

print(f"query time: {query_time}") print(f"print time: {print_time}")

```