Hi! 2,000,000 document in database and 200,000 document be queried?It takes about 4 seconds first time,and next time takes less than 0.5 second for the same query.Please explain it for me ? What method can shorten the time of the first queries? Thanks?
On Thu, October 21, 2010 06:47, ???? wrote:> Hi! > 2,000,000 document in database and 200,000 document be queried??It takes > about 4 seconds first time,and next time takes less than 0.5 second for the > same query.Please explain it for me ? What method can shorten the time of the > first queries? Thanks??The first time xapian has to read from disk, which is slow. The second time data is cached in RAM, which is faster. This is common across all applications. Regards Henry