Hello everyone
i am creating a sports database and the games can take place at day or night. Do you think that using a true/false statement or creating another table for day/night would be better?
Thanks for your input
From a pure performance perspective, the boolean field will be faster. But that won't be a concern in the kind of database you're building. I would make it a text field that gets either "Day" or "Night" in there. As long as your users only touch forms you won't have to worry about typos, because you can just put those values in a combo box (no real need for a lookup table with only two values that won't ever change).
Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.