Page 1 of 1

Maximum Number of Files or Tagging Elements

Posted: Thu Jul 29, 2010 9:29 pm
by aprilmot
Hello Eran,
I have planned to use CodeLite for a project which has almost 2300files in it. We will have almost 80000 Taggable Elements in them. In future the number of files and the Taggable elements will grow. Will this affects CodeLite performance. Can SQLite handle such a big database.

Please let me know the limit(files/taggable elements) upto which CodeLite can handle without major performance difference. Also is it possible to replace SQLite by MYSQL/PostGre for storing Taggable Elements.

Thank you in Advance
Aprilmot.

Re: Maximum Number of Files or Tagging Elements

Posted: Fri Jul 30, 2010 7:36 am
by eranif
aprilmot wrote:I have planned to use CodeLite for a project which has almost 2300files in it. We will have almost 80000 Taggable Elements in them. In future the number of files and the Taggable elements will grow. Will this affects CodeLite performance. Can SQLite handle such a big database.
codelite project is using codelite itself for developing. there are about 1500 source files in codelite workspace without any performance impact. I don't think it will be a problem (there are 102,800 tags in codelite's tags file)
aprilmot wrote:Also is it possible to replace SQLite by MYSQL/PostGre for storing Taggable Elements.
It is possible, but for its purpose, SQLite is the fastest between the three.
MYSQL/PGSQL are good databases when high level of concurrency is required (which is not the case in codelite)

Eran