search

dotancohen / squeal

Database explorer with a focus on breadth, not depth.
2 stars 0 forks source link

Showing tables' details is slow on large tables. #3

Closed dotancohen closed 10 years ago

dotancohen commented 10 years ago

This is probably due to RAND(). Instead, since we know the amount of rows in the table, on tables with a primary key we should choose ids randomly in Python and then select those.

dotancohen commented 10 years ago

For this, we should store in the Table object the output of "DESCRIBE TABLE" (self.columns = {}) and we could then parse it for a primary key.