how to speed up gino.create_engine

[panla]

costs too much time

import gino

engine = await gino.create_engine(...)

if I want to change engine when i write data, gino.create_engine costs too much time .
is there a better idea to speed up ?

[mikekeda]

you could keep it open and reuse, so you don't need to open it for each request

[panla]

thanks, but I want to select data by a engine and create/update/delete data by another engine.

[wwwjfy]

engine only needs to be initialized once and kept references

[panla]

engine only needs to be initialized once and kept references

import gino
from gino_starlette import Gino

db = Gino(...)

async def get_write_engine():
    return await gino.create_engine(WRITE_DSN)

engine = None

async def save(self):

    if WRITE_DSN != READ_DSN:
        global engine
        bind = engine or await get_write_engine()
        engine = bind
        obj = await self.create(bind=engine)
        return obj
    return await self.create()

effective