Gossamer Forum
Home : Products : DBMan : Discussions :

Re: [Lex] problem when db file gets big

Quote Reply
Re: [Lex] problem when db file gets big In reply to
Yes, it has been documented that the databases will start to act strange once they get to be about 1 meg or more in size.

The readme file states: You can expect reasonable performance for database approaching 1 MB though.


What you can do is to use the external text file mod and actually store the articles (for example) within external files and then call that field when the record is displayed.

That is what I do with the DBMan FAQ which has @ 1400 records. The external files amount to over 6 megs.

What you may need to do is to create a new field which would contain search words as the external files are not searchable. That way people can still search for relevant information by means of the search words you define.

I recently found within the FAQ a routine that will automatically convert current databases to move the textarea field to an external text file. I think you will find this in the FAQ noted below under "Files".

This is one solution for not having to try to get all your mods to work with the SQL version.

Unoffical DBMan FAQ

http://creativecomputingweb.com/dbman/index.shtml/
Subject Author Views Date
Thread problem when db file gets big Lex 3260 May 21, 2004, 7:18 PM
Thread Re: [Lex] problem when db file gets big
LoisC 3195 May 21, 2004, 11:40 PM
Post Re: [LoisC] problem when db file gets big
Lex 3112 Jun 13, 2004, 8:40 AM