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 (while probably making it more complicated )I am trying to make the database as flexible as possible as I have a couple of 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 to standardize 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 a fixed 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 in the main database. Would this slow things down a lot?Otherwise I could setup a separate database with the 15 fields and a key filed to match to the main database, but then there is that nasty problem of displaying the results of the search.The main reason for not wanting to put these 15 fields in the main database is that I will probably have a few different categories with differing numbers of fields required and then of course some day I might need more than what I entered into the database in the beginning and would have to shut down the server to make changes. And of course I might never need all of 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:

    
  1. Re: database performance/design question (John Peacock 2000)
  2. database performance/design question (stuff 2000)
Hello,I am trying to re-design a site and want to simplify some things (while probably making it more complicated )I am trying to make the database as flexible as possible as I have a couple of 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 to standardize 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 a fixed 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 in the main database. Would this slow things down a lot?Otherwise I could setup a separate database with the 15 fields and a key filed to match to the main database, but then there is that nasty problem of displaying the results of the search.The main reason for not wanting to put these 15 fields in the main database is that I will probably have a few different categories with differing numbers of fields required and then of course some day I might need more than what I entered into the database in the beginning and would have to shut down the server to make changes. And of course I might never need all of 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)