You are not logged in.
- Topics: Active | Unanswered
#1 2014-06-29 05:39:51
- edwinsn
- Member
- Registered: 2010-07-02
- Posts: 1,218
Want to put FTS tables in separated DB, use ATTACH DATABASE or?
Hello Arnaud,
I use a main sqlite DB to store data, and now I need to full-text index those data, I want to put the FTS tables in a separated sqlite DB for good reasons including reduce main DB size.
So what's the proper way of doing this? I assume I should use a separated TSQLRestClientDB instance pointing to the separated sqlite DB, right? Or use ATTACH DATABASE and how?
Thank you in advance and I wish you have a nice weekend 
Delphi XE4 Pro on Windows 7 64bit.
Lazarus trunk built with fpcupdelux on Windows with cross-compile for Linux 64bit.
Offline
#2 2014-06-29 06:18:03
Re: Want to put FTS tables in separated DB, use ATTACH DATABASE or?
Simply try to use an external sqlite3 table.
But I am not sure it will work as expected.
attach db won't work either on a FTS table I suspect..
So a separated TSQLRestClientDB instance is perhaps the solution.
Offline
#3 2014-06-29 06:47:04
- edwinsn
- Member
- Registered: 2010-07-02
- Posts: 1,218
Re: Want to put FTS tables in separated DB, use ATTACH DATABASE or?
Sounds great, thanks ab.
Delphi XE4 Pro on Windows 7 64bit.
Lazarus trunk built with fpcupdelux on Windows with cross-compile for Linux 64bit.
Offline