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:
[WebDNA] Bug in [thisurlplusget] on v7 (2011)
Showif probably dumb question (1997)
Graphical display of sales volume (2003)
MacAuthorize order data fields WAS:How To question... (1997)
RE: Force a number with JavaScript (1998)
RE: ShowNext Command (1997)
[WebDNA] Sendmail BCC bug still exists (2015)
searchable list archive (1997)
Dummy Credit Card Number for debug? (1997)
Memory Error message (1998)
Tracking (2004)
Webcatalog server support (1997)
2.0 Info (1997)
Searching for a search solution (2000)
WebCat2b13MacPlugin - [math][date][/math] problem (1997)
Need some extra eyes (2003)
New Documentation For WebCatalog 1.6 (1996)
WebDelivery downloads alias, not original ? (1997)
Allow/Deny with Webcat? (1998)
Need relative path explanation (1997)