CODEWITHSUNDEEP
sqlitedelete-row
Woody
Woody

Reputation: 1

SQLite delete limit

The question is simple: Is there a limit on rows you can delete in SQLite.

I have a database 42 tables, one of the tables consists of 75000 rows. When I want to delete them, SQLManager in FF crashes.

So is there a limit on deleting rows in SQLite?

Upvotes: 0

Views: 765

Answers (1)

paxdiablo
paxdiablo

Reputation: 881383

I've had no troubles deleting hundreds of thousands of rows in SQLite so, if it's a problem, it's not with the DBMS itself. It may be a problem with SQLManager but I'm not qualified to comment on that.

My suggestion would be to use the tools that SQLite provides (or your own code) rather than using some third-party product - that way, you'll know that any limitations you find (and I suspect, based on experience, that it won't be many) will be due to the product itself.

Upvotes: 3

Related Questions