Ormlite DAO in android becomes very slow when you are querying over several thousand results

Are you having trouble querying data through the Ormlite DAO when there are several thousand results.

code:

List<Point> pl = db.getPointsDAO().queryBuilder().where().
            eq("route_id", croute).query();

      

        
        
        
      

    

When I want to get a large list of points List<Point> pl

for the current route croute

, I need to wait 40 seconds for 40,000 points.

where Point.class:

@DatabaseTable(tableName = "points")
public class Point extends BaseEntity {
    @DatabaseField(generatedId = true)
    private Integer point_id;
    @DatabaseField(canBeNull = false)
    ...
    @DatabaseField(canBeNull = false)
    private Double dose;
    @DatabaseField(dataType=DataType.DATE_STRING, format="yyyy-MM-dd HH:mm:ss")
    public Date date;
    @DatabaseField(canBeNull=true,foreign=true)
    private Route route;

public Point() {
    super();
};
... ...
}

      

        
        
        
      

    

and Route.class:

@DatabaseTable(tableName = "routes")
public class Route extends BaseEntity {

    @DatabaseField(generatedId = true)
    private Integer route_id;

    @DatabaseField(canBeNull = true)
    private String name;

    @ForeignCollectionField(eager = false)
    ForeignCollection<Point> points;

    public Route() {
        super();
    }
    ... ...
}

      

        
        
        
      

    

Some ideas what I am doing wrong?

Thanks, Toni