2011/5/30 Denis Kuzmenok <forward...@ukr.net>: > I have a database with n-gram field, about 5 millions documents. QTime > is about 200-1000 ms, database is not optimized because it must reply > to queries everytime and data are updated often. Is it normal? > Solr: 3.1, java -Xms2048M -Xmx4096M > Server: i7, 12Gb
Start by optimizing it, it wont "stop working" due to a optimize. Some other vital info is the size of the index, disk type used etc (SSD, SATA, IDE..) -- Mvh Tor Henning Ueland