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/
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/