There is about 1 milion records.
Query is needed for the pagination system.

Query looks like this:

```
SELECT field1, field2, field3 FROM table 
WHERE field4 = '$value' 
ORDER BY field5 ASC limit $offset, 30;

```

There is index on field4 and field5.

All fields are varchar type.
Field5 was tested as int but no real improvement notice.

Right now query with `limit 0, 30` takes about 1 second, but query with `limit 119970, 30` takes about 20 seconds.

Is this realistic to obtain result less than 0.1 second on paginated pages? Such loading time is needed for the website to offer good user experience.

EXPLAIN (select with `limit 0,30`)

```
id: 1
select_type: SIMPLE
table: table
type: index
possible_keys: NULL
key: field5
key_len: 768
ref: NULL
rows: 223636
Extra: Using where

```