Hi,

What "fastest" - table design shouldn't be about speed, but about
consistency and normalized data structures.


With regards,

Martijn Tonies
InterBase Workbench - the developer tool for InterBase & Firebird
Firebird Workbench - the developer tool for Firebird
Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."

> Hello
>
> Wich table design is the fastest of these two:
>
> User_info
> =========
> Userid (PK)
> First_name
> Last_name
> Password
> MobileNo
> MobileNo_Unformatted
> ExtensionNo
> ExtensionNo_Unformatted
> AltNo
> AltNo_Unformatted
> MiniCall
> MiniCall_Unformatted
>
> Or:
>
> User_info
> =========
> Userid (PK)
> First_name
> Last_name
> Password
>
> User_Number
> ===========
> UserId (FK)
> Number
> Number_Unformatted
> TypeId
>
> Typeid specify the numbertype (mobile, extension, altnumber, minicall
> etc etc)
> The unformatted field is the number without any separators (formated
> number can be +46-221-111 01 and the unformatted 4622111101), the
> unformatted field is used when the user want to search after a number.
>
> I got the second layout now with an index on number_unformatted
>
> Typical search:
> Select * from user_info ui, user_number un WHERE ui.userid=un.userid AND
> number_unformatted like '46221%'
>
> Thanks,
> Jonas
>
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>