Searching Multiple DBs
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 11919
interpreted = N
texte = Blokes and Blokettes...I was trying to experiment with a fairly large database (160,000 records - 12 fields) that was a bit unmanageable as a single file (around 16 megs on disk), and so I thought I'd be clever and split it up into 12 different databases of roughly 15,000 records a piece.I was thinking I could perform a search treating all of these files as ONE, by doing something like:
Which doesn't work, since it appears that it looks as the list of databases I gave it as one REALLY LONG filename.I've since re-joined the databases into ONE file and searching works fine (aside from needing TONS of RAM), but I could see searching multiple databases having the same form as being a rather useful function - so, is it possible or WILL it be possible in the future?Dan Keldsen - djk@delphigroup.comDirector, I.S. - webmaster@delphigroup.comDelphi Consulting Group, Inc. - http://www.delphigroup.com/100 City Hall Plaza - ph: 617-247-1511Boston, MA 02108-2106 - fax:617-247-4957
Associated Messages, from the most recent to the oldest:
Blokes and Blokettes...I was trying to experiment with a fairly large database (160,000 records - 12 fields) that was a bit unmanageable as a single file (around 16 megs on disk), and so I thought I'd be clever and split it up into 12 different databases of roughly 15,000 records a piece.I was thinking I could perform a search treating all of these files as ONE, by doing something like:
Which doesn't work, since it appears that it looks as the list of databases I gave it as one REALLY LONG filename.I've since re-joined the databases into ONE file and searching works fine (aside from needing TONS of RAM), but I could see searching multiple databases having the same form as being a rather useful function - so, is it possible or WILL it be possible in the future?Dan Keldsen - djk@delphigroup.comDirector, I.S. - webmaster@delphigroup.comDelphi Consulting Group, Inc. - http://www.delphigroup.com/100 City Hall Plaza - ph: 617-247-1511Boston, MA 02108-2106 - fax:617-247-4957
Dan Keldsen
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
Signal Raised (1997)
Thanks Grant (1997)
international time (1997)
Summary layout (1997)
creating writefile data from a nested search (1997)
Sami -pdf (1998)
emailer (1997)
[OT] Imagemagick (2004)
[SearchString] (1998)
createfolder not behaving as expected (1999)
WebCat Code and WebStar Search? (2000)
Part Html part WebDNA (1997)
referrer and no caches (1997)
SORRY (1997)
shipcost (1997)
Providing hard copy of database to client (1997)
shownext and searches (2002)
customizing the color of user's pages (1997)
View order not right (1997)
TCPConnect / Current Temperature (2004)