Hi to you,

I'm asking to me (and now you too) the following:

I was working on an message-board-system a few days before and for the search-function at this board, it makes for each subboard an indexfile, for example index.board1, index.board2 and so on...

Is it possible to do the same in dbman with the entries?

For example you have 10 categories in your database, is it possible to manage with your dbman sript(s) 10 flat-text-files (without relational)???

In this message-board-sy<stem you can search in one board only (as here) or in all board (like here).

Possible in dbman too?

I ask this question, because, I hope to manage with this a lot more than the 1MB of record entries.

Pit

It is possible to have as many databases as you want. But I don't know how you would search all of them at once.


JPD
http://www.jpdeni.com/dbman/

Hi Carol,

my idea is, to have as many db-files, as categories.

And couldn't the search do the following:

If the user has defined over a drop-down-field, that the search is in one categorie, if he defines a search over all categories, than the script opens the first db-file, than the second, than the third and so on?

All the found records have to save in a temporary file and at the end this file can be read for the search result.

Oh, I know, it would be one of the mods, that would be a very lot of work, but with this mod, everybody could go over the 1MB limit of dbman.

Do you mean, it is possible?

Pit

I suppose it might be possible. It would mean rewriting sub query completely, though. If you want to tackle it, go ahead. It's a little more than my brain can handle right now, though.

JPD
http://www.jpdeni.com/dbman/

Hi Carol,

:-((

I understand you, perhaps we can do it together (for the others, that mean, she does the work and I the testing:-))?

Pit

Your idea sounds like it might end up taking a long time to do searches ... having to search through many db files.

But perhaps I'm not clearly understanding what you wanted to do?

Unoffical DBMan FAQ
http://webmagic.hypermart.net/dbman/

Hi Lois,

yes, you are right, but I see in it the only possibility to handle a database with for example 10MB Diskspace without using the sql version.

Pit

I understand what you're saying. But there will be no difference in the time it takes to search through 10 files of 1M each and 1 file of 10M. It's still searching through 10M.


JPD
http://www.jpdeni.com/dbman/

Hi Carol,

Oh, I thought, that the problem was a greater than 1MB flat-test file.

So, then I have to upload to the sql version in every case, if I`m going over the 1mB Limit?

Pit

Yes. However, from what others have said, the database will still work up to 2M in size. It just will be slower. After 2M, it's so slow that the browser times out.



JPD
http://www.jpdeni.com/dbman/

Oh, sh...

Okay, is that in every cases of flat-text files so, or only with dbman?

Pit

Probably with every one.

The problem with a flat-file ASCII based database is that the script must read through every ASCII character to find matches in a search. Most of the time that doesn't take too long. But when there are a lot of characters, it does take a while.

I did think about your proposed splitting of the file. If your search results ended up having more than one page and if you created temporary files to hold the search results, the second and later pages would be very quick. It's just the first page -- getting the first search results to write into the temporary file -- that would take a long time and might time out your browser.

JPD
http://www.jpdeni.com/dbman/

Hi Carol,

aha, now I know.

Carol, when did you upgrade you dbman to sql?


Pit

I haven't as yet. I've been too busy answering questions and writing mods to have the time to really look at DBMan-SQL. One of these days!!

JPD
http://www.jpdeni.com/dbman/