I would like to convert my project from Morphia to Spring Data, but some basic queries are very slow with Spring Data.
For instance:
@Override
public List<PTDefaultBlacklistContact> findByBlacklistId(ObjectId defaultBlacklistId, int limit, int offset, String sortBy) {
Query query = Query.query(Criteria.where("blacklistId").is(defaultBlacklistId));
if (limit != 0)
query.limit(limit);
if (offset != 0)
query.skip(offset);
if (StringUtils.hasLength(sortBy))
query.with(new Sort(sortBy));
log.debug("findByBlacklistId query={}", query);
return mongoOperations.find(query, PTDefaultBlacklistContact.class);
}
takes ~ 2 minutes
And with morphine
@Override
public List<PTDefaultBlacklistContact> findByBlacklistId(ObjectId defaultBlacklistId, int limit, int offset, String sortBy) {
Query<PTDefaultBlacklistContact> q = createQuery().disableValidation().filter("blacklistId", defaultBlacklistId).limit(limit)
.offset(offset);
if (StringUtils.hasLength(sortBy)) {
q.order(sortBy);
}
return q.asList();
}
It takes ~ 5 seconds.
My configuration is basic, so it's quiet, strange to understand. I just have this in my .yml application, and there is an automatic w760> mongodb boot configuration.
spring.data.mongodb.uri: mongodb://serv1,serv2,serv3/${mongodb.database}
Any idea? I am wondering if life cycle events can cause it.
thank
change
Models:
PTDefaultBlacklistContact
@Document(collection = "PTDefaultBlacklistContact")
public class PTDefaultBlacklistContact extends PTModel {
private static final long serialVersionUID = 1L;
@Deprecated
@DBRef
protected PTDefaultBlacklist blacklist;
private String identifier;
@Indexed
private ObjectId blacklistId;
private List<PTHistory> history;
public PTDefaultBlacklistContact() {
}
@Override
public int hashCode() {
int prime = 31;
int result = 1;
result = prime * result + ((blacklistId == null) ? 0 : blacklistId.hashCode());
result = prime * result + ((identifier == null) ? 0 : identifier.hashCode());
return result;
}
@Override
public boolean equals(Object obj) {
if (this == obj) {
return true;
}
if (getClass() != obj.getClass()) {
return false;
}
PTDefaultBlacklistContact other = (PTDefaultBlacklistContact) obj;
if (blacklistId == null) {
if (other.blacklistId != null) {
return false;
}
} else if (!blacklistId.equals(other.blacklistId)) {
return false;
}
if (identifier == null) {
if (other.identifier != null) {
return false;
}
} else if (!identifier.equals(other.identifier)) {
return false;
}
return true;
}
@Override
public String toString() {
return "PTDefaultBlacklistContact{" +
"identifier='" + identifier + '\'' +
", blacklistId=" + blacklistId +
'}';
}
public List<PTHistory> getHistory() {
return history;
}
public void setHistory(List<PTHistory> history) {
this.history = history;
}
public String getIdentifier() {
return identifier;
}
public void setIdentifier(String identifier) {
this.identifier = identifier;
}
@Deprecated
public PTDefaultBlacklist getBlacklist() {
return blacklist;
}
@Deprecated
public void setBlacklist(PTDefaultBlacklist blacklist) {
this.blacklist = blacklist;
}
public ObjectId getBlacklistId() {
if (blacklist != null) {
blacklistId = blacklist.getId();
}
return blacklistId;
}
public void setBlacklistId(ObjectId blacklistId) {
this.blacklistId = blacklistId;
}
}
Pthistory
public class PTHistory {
private Long date;
@DBRef
private PTCampaign campaign;
public Long getDate() {
return date;
}
public void setDate(Long date) {
this.date = date;
}
public PTCampaign getCampaign() {
return campaign;
}
public void setCampaign(PTCampaign campaign) {
this.campaign = campaign;
}
}