database performance/design question
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 31474
interpreted = N
texte = Hello,I am trying to re-design a site and want to simplify some things (whileprobably making it more complicated
)I am trying to make the database as flexible as possible as I have a coupleof other sites I would like to eventually launch using the same code base.I need to include some categories for my users to search on and I want tostandardize the database. What I am thinking of doing is the following.in my main database have a field of 'categories' This field would be of afixed length (fixed by my coding) of say 15 chars.The data would be simply 010011101010100In the search I would use [GetChars start=x&end=y][category][/GetChars]Is this just a dumb idea? I am trying to not have to have these 15 fields inthe main database. Would this slow things down a lot?Otherwise I could setup a separate database with the 15 fields and a keyfiled to match to the main database, but then there is that nasty problem ofdisplaying the results of the search.The main reason for not wanting to put these 15 fields in the main databaseis that I will probably have a few different categories with differingnumbers of fields required and then of course some day I might need morethan what I entered into the database in the beginning and would have toshut down the server to make changes. And of course I might never need allof the fields I enter so I would waste space.Thanks for any suggestions.Dale-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to
Associated Messages, from the most recent to the oldest:
Hello,I am trying to re-design a site and want to simplify some things (whileprobably making it more complicated )I am trying to make the database as flexible as possible as I have a coupleof other sites I would like to eventually launch using the same code base.I need to include some categories for my users to search on and I want tostandardize the database. What I am thinking of doing is the following.in my main database have a field of 'categories' This field would be of afixed length (fixed by my coding) of say 15 chars.The data would be simply 010011101010100In the search I would use [GetChars start=x&end=y][category][/GetChars]Is this just a dumb idea? I am trying to not have to have these 15 fields inthe main database. Would this slow things down a lot?Otherwise I could setup a separate database with the 15 fields and a keyfiled to match to the main database, but then there is that nasty problem ofdisplaying the results of the search.The main reason for not wanting to put these 15 fields in the main databaseis that I will probably have a few different categories with differingnumbers of fields required and then of course some day I might need morethan what I entered into the database in the beginning and would have toshut down the server to make changes. And of course I might never need allof the fields I enter so I would waste space.Thanks for any suggestions.Dale-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to
stuff
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:
Anomaly ? causes NT application event log to overflow (1997)
multiple search commands (1997)
Verifying SSL on Page (2002)
WebSTAR 2.1 freezes my Mac (1997)
[delete] problem (1997)
apostrophe in search item (1997)
Snake Bites (1997)
WebCat2b13MacPlugIn - More limits on [include] (1997)
Members register & gain access system (1998)
New WebCatalog Version !!! (1997)
Country & Ship-to address & other fields ? (1997)
founditems / writefile (2005)
A new perspective ... (2005)
Trouble with Netscape (1998)
[SearchString] problem with [search] context (1997)
RE: Purchased cart being overwritten - still !?? (1997)
Carts & Refering URLs (1997)
Web Site Hosting (2000)
Viewing old carts (was FEW QUESTIONS) (1997)
Finding max value for a field (1997)