There is a table named vssq_user contains 1,000,000 records,the following
SQL query takes more than 20 seconds:
SELECT * FROM VSSQ_USER LIMIT 10 OFFSET 600000
The DDL of the table is:
CREATE TABLE
VSSQ_USER
(
ID_ CHAR(32) NOT NULL,
COMPANY_ CHAR(32) NOT NULL,
EMAIL_ VARCHAR(256) NOT NULL,
PASSWORD_ VARCHAR(256) NOT NULL,
SALT_ VARCHAR(64),
NAME_ VARCHAR(1024) NOT NULL,
OTHER_NAME_ VARCHAR(1024),
GENDER_ CHAR(1) NOT NULL,
TEL_ VARCHAR(16),
IM_ VARCHAR(16),
ADDRESS_ VARCHAR(1024),
BIRTHDAY_ DATE,
REMARK_ CLOB,
VALID_STATUS_ CHAR(1) DEFAULT '1' NOT NULL,
MODIFIED_TIME_ TIMESTAMP NOT NULL,
CREATED_TIME_ TIMESTAMP NOT NULL,
VERSION_ INTEGER NOT NULL,
PRIMARY KEY (ID_),
CONSTRAINT FK_USER_COMPANY FOREIGN KEY (COMPANY_) REFERENCES
VSSQ_COMPANY (ID_) ON
DELETE
RESTRICT
);
Is there anyway to optimize performance?
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/groups/opt_out.
