|  09-06-2011, 07:28 PM | #1 | 
| Member  Posts: 14 Karma: 10 Join Date: Aug 2011 Device: Kindle3, Sony PRS-505 | 
				
				Search Performance
			 
			
			Does Calibre database use indexes to improve search performance?  How can I speed up search for a large library of books? Currently it may take up to 30 sec. on Win 7 Core 2 Duo CPU with 3GB of memory. Is it possible to port database in MS SQL Server? Thank you. | 
|   |   | 
|  09-06-2011, 08:26 PM | #2 | 
| US Navy, Retired            Posts: 9,897 Karma: 13806776 Join Date: Feb 2009 Location: North Carolina Device: Icarus Illumina XL HD, Kindle PaperWhite SE 11th Gen | 
			
			Go to Preferences - Searching and limit the columns you search.  I have a 8800+ book library and limit my searches to title, authors, tags, series, and publisher and a search takes about a second or two.
		 | 
|   |   | 
| Advert | |
|  | 
|  | 
| 
 | 
|  Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post | 
| Problem using 'Advanced Search' with 'Search in Forum' | Wetdogeared | Feedback | 6 | 06-21-2011 09:37 AM | 
| Scalability and performance | blither | Calibre | 1 | 08-10-2010 08:31 PM | 
| DR800 Performance | jjansen | iRex | 18 | 08-03-2010 09:10 PM | 
| Classic Battery performance after softroot? | Sylver | Barnes & Noble NOOK | 14 | 07-26-2010 10:51 PM | 
| Google Book Search to search full-text books online | Bob Russell | Deals and Resources (No Self-Promotion or Affiliate Links) | 1 | 08-19-2006 12:13 PM |