Jump to content

help with 3 tables..


Recommended Posts


Im looking for much needed advice. I have 3 user tables in a database set to 25000 max entries, i have over 60000 users. so table 1 and 2 are full, with 10,000 entries in table 3.

This runs my multiplayer pool site, www.8baller.co.uk - he said he coded it it like that ( mutliple user tables ) to make it faster etc. coz the game is really mysql intensive. Iv just bought a dedicated server and now everything is hosted in the same place, so i can now start messing with the database and creating my own stats etc..

But how do i get values of all 3 tables? so say...i want to display the newest user...so it would be entry 10001 in user table 3.. how on earth do i find out which table number the newest user is in? and how do i say pick the guy with the highest score out of all 3 user tables?

Im confused lol.
Link to comment
Share on other sites

[quote]he said he coded it it like that ( mutliple user tables ) to make it faster etc.[/quote]

How odd.... So do you have some existing code we can look at?  He must either be looking at rownum or a auto incrementing ID or something.

Maybe show us the code used to 'insert a new user' into the DB?

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.