Page 1 of 2 12 LastLast
Results 1 to 15 of 22

Thread: Relational Database Help - Serious People only

  1. #1 | Top
    Join Date
    Jul 2006
    Location
    internet
    Posts
    39,189
    Thanks
    7,082
    Thanked 17,235 Times in 10,345 Posts
    Groans
    1,025
    Groaned 1,490 Times in 1,337 Posts
    Blog Entries
    5

    Default Relational Database Help - Serious People only

    Hi everyone. If I'm not mistaken a few of you may know some stuff about relational databases. I do too, to a certain extent, but I kinda suck. I have some questions if anyone could help me out. PM me or post in this thread if you can answer some questions I have. thanks..


    ---

    Quote Originally Posted by Mott the Hoople View Post
    Grind is basically right
    Quote Originally Posted by Phantasmal View Post
    Grindís got you beat by miles. He is very intelligent.

  2. #2 | Top
    Join Date
    Dec 2006
    Location
    In your mind
    Posts
    7,458
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Groans
    0
    Groaned 0 Times in 0 Posts

    Default

    Yeah, I know all about whatever that is.
    There is much to be said in favour of modern journalism. By giving us the opinions of the uneducated, it keeps us in touch with the ignorance of the community.

    -Oscar Wilde

  3. #3 | Top
    Join Date
    Jul 2006
    Location
    internet
    Posts
    39,189
    Thanks
    7,082
    Thanked 17,235 Times in 10,345 Posts
    Groans
    1,025
    Groaned 1,490 Times in 1,337 Posts
    Blog Entries
    5

    Default

    apparently you did not understand the meaning of serious O_O


    ---

    Quote Originally Posted by Mott the Hoople View Post
    Grind is basically right
    Quote Originally Posted by Phantasmal View Post
    Grindís got you beat by miles. He is very intelligent.

  4. #4 | Top
    Join Date
    Jul 2006
    Posts
    61,320
    Thanks
    7,144
    Thanked 8,821 Times in 6,166 Posts
    Groans
    5,805
    Groaned 1,532 Times in 1,444 Posts
    Blog Entries
    3

    Default

    The basic problem with relational databases is numeric overload - where you have more info coming through the data pipe than coming out. Which could cause you a lot of headaches with your data centers and other relational structures in the thing you're making. You need to learn a little about PHP to be able to effectively combat such problems.
    Last edited by FUCK THE POLICE; 08-20-2008 at 08:29 PM. Reason: Suck my dick Beefy, it's just two fucking letters for your nosy prying eyes! And this is one more!
    "Do not think that I came to bring peace... I did not come to bring peace, but a sword." - Matthew 10:34

  5. #5 | Top
    Join Date
    Jul 2006
    Location
    internet
    Posts
    39,189
    Thanks
    7,082
    Thanked 17,235 Times in 10,345 Posts
    Groans
    1,025
    Groaned 1,490 Times in 1,337 Posts
    Blog Entries
    5

    Default

    k your both so banned.


    ---

    Quote Originally Posted by Mott the Hoople View Post
    Grind is basically right
    Quote Originally Posted by Phantasmal View Post
    Grindís got you beat by miles. He is very intelligent.

  6. #6 | Top
    Join Date
    Aug 2006
    Location
    Federal Way, WA
    Posts
    68,354
    Thanks
    18,375
    Thanked 18,676 Times in 14,049 Posts
    Groans
    628
    Groaned 1,136 Times in 1,080 Posts

  7. #7 | Top
    Join Date
    Jul 2006
    Location
    New Jersey
    Posts
    14,887
    Thanks
    66
    Thanked 139 Times in 77 Posts
    Groans
    4
    Groaned 6 Times in 5 Posts
    Blog Entries
    1

    Default

    I know a little.
    What app are you using to query?
    "Fuck you niggers" July 11, 2009 Tinfoil explaining how conservatives are unfairly labeled as racists.

    "You deserve to be beheaded and for your head to placed on a pike, in the middle of the park, where children can see what happens to those that act the way you do." August 5, 2009 USFreedom911's response to a left leaning opinion.

  8. #8 | Top
    Join Date
    Dec 2006
    Posts
    72,349
    Thanks
    6,678
    Thanked 12,316 Times in 9,824 Posts
    Groans
    14
    Groaned 510 Times in 483 Posts
    Blog Entries
    1

    Default

    Im a sql master. What do you need?

  9. #9 | Top
    Join Date
    Jul 2006
    Location
    internet
    Posts
    39,189
    Thanks
    7,082
    Thanked 17,235 Times in 10,345 Posts
    Groans
    1,025
    Groaned 1,490 Times in 1,337 Posts
    Blog Entries
    5

    Default

    nice asshat. i'll get in touch with you.


    ---

    Quote Originally Posted by Mott the Hoople View Post
    Grind is basically right
    Quote Originally Posted by Phantasmal View Post
    Grindís got you beat by miles. He is very intelligent.

  10. #10 | Top
    Join Date
    Jul 2006
    Location
    Canton, Oh
    Posts
    3,663
    Thanks
    135
    Thanked 161 Times in 112 Posts
    Groans
    10
    Groaned 5 Times in 5 Posts
    Blog Entries
    7

    Default

    I'm a Web Developer grind, and have designed and maintained over 100 databases. If you don't get help, let me know and I'll take a stab at it.
    You Are Not So Smart Podcast - A celebration of Self-Delusion

  11. #11 | Top
    Join Date
    Jul 2006
    Location
    internet
    Posts
    39,189
    Thanks
    7,082
    Thanked 17,235 Times in 10,345 Posts
    Groans
    1,025
    Groaned 1,490 Times in 1,337 Posts
    Blog Entries
    5

    Default

    question about temporary tables, (assume I actually need to use one)

    A) what happens if two people query for information through a temporary table at the exact same time, is this going to cause issues?

    B) If it will cause issues, what's my solution? Can I create dynamic temporary tables? I've been seeing a lot of stuff about stored procedures but I'm not sure that applies to me plus I think it seems a little bloated for what I am doing.

    No, JOINS etc aren't probably going to work for me in this instance...


    ---

    Quote Originally Posted by Mott the Hoople View Post
    Grind is basically right
    Quote Originally Posted by Phantasmal View Post
    Grindís got you beat by miles. He is very intelligent.

  12. #12 | Top
    Join Date
    Jul 2006
    Posts
    17,247
    Thanks
    846
    Thanked 4,225 Times in 2,940 Posts
    Groans
    304
    Groaned 343 Times in 329 Posts

    Default

    Are you using MS SQL Server or??? Local temp tables only have scope within the current session. Global temp tables can be accessed by other sessions. But you might want to use a table variable instead of a local temp table.
    Leviticus 19:33 And if a stranger sojourn with thee in your land, ye shall not do him wrong. 34 The stranger that sojourneth with you shall be unto you as the homeborn among you, and thou shalt love him as thyself; for ye were strangers in the land of Egypt: I am the LORD your God.

  13. #13 | Top
    Join Date
    Jul 2006
    Posts
    17,247
    Thanks
    846
    Thanked 4,225 Times in 2,940 Posts
    Groans
    304
    Groaned 343 Times in 329 Posts

    Default

    Table variables usually outperform temp tables.
    Leviticus 19:33 And if a stranger sojourn with thee in your land, ye shall not do him wrong. 34 The stranger that sojourneth with you shall be unto you as the homeborn among you, and thou shalt love him as thyself; for ye were strangers in the land of Egypt: I am the LORD your God.

  14. #14 | Top
    Join Date
    Jul 2006
    Location
    internet
    Posts
    39,189
    Thanks
    7,082
    Thanked 17,235 Times in 10,345 Posts
    Groans
    1,025
    Groaned 1,490 Times in 1,337 Posts
    Blog Entries
    5

    Default

    I'm using mysql.

    I don't think I want a temp table accessed by other sessions.


    ---

    Quote Originally Posted by Mott the Hoople View Post
    Grind is basically right
    Quote Originally Posted by Phantasmal View Post
    Grindís got you beat by miles. He is very intelligent.

  15. #15 | Top
    Join Date
    Jul 2006
    Posts
    17,247
    Thanks
    846
    Thanked 4,225 Times in 2,940 Posts
    Groans
    304
    Groaned 343 Times in 329 Posts

    Default

    It won't be. Temp tables in mysql only have scope within the current session.
    Leviticus 19:33 And if a stranger sojourn with thee in your land, ye shall not do him wrong. 34 The stranger that sojourneth with you shall be unto you as the homeborn among you, and thou shalt love him as thyself; for ye were strangers in the land of Egypt: I am the LORD your God.

Similar Threads

  1. Replies: 14
    Last Post: 09-17-2008, 12:20 PM
  2. What Most People Think
    By jollie in forum Current Events Forum
    Replies: 1
    Last Post: 05-19-2008, 01:51 PM
  3. why are people so down on hc
    By Don Quixote in forum Current Events Forum
    Replies: 39
    Last Post: 04-04-2008, 05:18 AM
  4. FBI aims for world's largest biometrics database
    By Socrtease in forum Current Events Forum
    Replies: 2
    Last Post: 12-22-2007, 03:11 PM
  5. People here
    By Cancel7 in forum Off Topic Forum
    Replies: 41
    Last Post: 09-15-2006, 04:15 PM

Bookmarks

Posting Rules

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •