samedi 12 mars 2016

Oracle too many data, computer get stuck

I want to let each release have a unique release id

I'm using sqlitebrowser.

    update songs
    set release_id = (
        select min(release_id)
        from songs t2
        where t2.release = songs.release 
    )

I used this command. but I have 100000 rows. And my computer has been getting stuck for an hour. It can get result if I delete row to 20.

Any better solution?

Aucun commentaire:

Enregistrer un commentaire