On 09/23/2008 02:42 PM, Ben A.H. wrote:
I figured that was what you meant... I guess my table didn't work (see above
message...don't ya' love plaintext :-O)...
Has anyone ever tried to benchmark the difference between utilizing ENUMs
vs. traditional relational databasing? I would think ENUM is
I figured that was what you meant... I guess my table didn't work (see above
message...don't ya' love plaintext :-O)...
Has anyone ever tried to benchmark the difference between utilizing ENUMs
vs. traditional relational databasing? I would think ENUM is ideal for items
I specified at the begin
Hello all,
Thank-you for all of your help, I was really surprised by the speed &
quality of responses. Below is a table I've created based on some reading I
did following everyone's suggestions (I hope the table shows correctly)...
I'm leaning towards the pure Relational as I like having all da
On Tue, Sep 23, 2008 at 6:13 PM, Olexandr Melnyk <[EMAIL PROTECTED]> wrote:
> Plus, if the same query is run very often and table is almost static,
> chances are high that the result will be in query cache.
>
Just realized that I haven't mentioned that this sentence is related to
storing states i
> It sounds like what you're looking for is an ENUM value:
>
> http://dev.mysql.com/doc/refman/5.0/en/enum.html
>
> Bear in mind when using this data-type that if you do want to add a new
> value (such as a new state/country), you will have to perform an ALTER
> TABLE statement, which can take some
On Tue, Sep 23, 2008 at 11:13 AM, Olexandr Melnyk <[EMAIL PROTECTED]> wrote:
> On 9/23/08, David Ashley <[EMAIL PROTECTED]> wrote:
>>
>> For example, for the 50 states, a lot of programmers would put this logic
>> in
>> the web script and just store the two-letter postal code in the database
>> t
On 9/23/08, David Ashley <[EMAIL PROTECTED]> wrote:
>
> For example, for the 50 states, a lot of programmers would put this logic
> in
> the web script and just store the two-letter postal code in the database
> table (but with no separate table for "states"). The mapping from "MI" to
> "Michigan"
On Mon, Sep 22, 2008 at 5:12 PM, Ben A.H. <[EMAIL PROTECTED]> wrote:
>
> There are various other fields that I believe could be handled like this
> for
> a cumulative performance boost. For example: country, state/province,
> gender, industry, occupation, ethnicity, language are all options that
>
Hi Ben,
It sounds like what you're looking for is an ENUM value:
http://dev.mysql.com/doc/refman/5.0/en/enum.html
Bear in mind when using this data-type that if you do want to add a new
value (such as a new state/country), you will have to perform an ALTER
TABLE statement, which can take some ti
Hello,
We are setting up a relatively common web application which collects "user
information"... Right off the bat our system will have over 200,000 USER
RECORDS so having an efficient database & lookup scheme is critical.
I am a programmer/developer with some education in databasing but my for
10 matches
Mail list logo
