Page 341 of 211,267, showing 20 records out of 4,225,326 total, starting on record 6,801, ending on 6,820
| # | Username | Text | |
|---|---|---|---|
| # | Aug 9th 2008, 05:39 | Howard`` | Databases |
| # | Aug 9th 2008, 05:39 | AD7six | Howard``: via query at a guess. |
| # | Aug 9th 2008, 05:40 | AD7six | Howard``: might be directly possible have a look at schemas although I (atm) assume they expect a db to exist beforehand |
| # | Aug 9th 2008, 05:40 | Howard`` | What I want to avoid is having a database with so much information that pulling 50 specific rows is going to strain the entire server |
| # | Aug 9th 2008, 05:40 | AD7six | Howard``: are you thinking of putting (e.g.) 26 dbs, split on the same server? |
| # | Aug 9th 2008, 05:41 | Howard`` | initially, after the first week or month i plan on spanning across a minimum of two servers |
| # | Aug 9th 2008, 05:41 | AD7six | Howard``: that's imo pretty much pointless. |
| # | Aug 9th 2008, 05:42 | AD7six | Howard``: indexes -> dedicated db server -> clusters -> sharding. |
| # | Aug 9th 2008, 05:42 | AD7six | premature optimization otherwise. |
| # | Aug 9th 2008, 05:42 | Howard`` | isn't there a performance gain if you have 10 databases of 100k rows rather than 1 database of 1 million rows? |
| # | Aug 9th 2008, 05:43 | AD7six | Howard``: a million rows isn't a lot |
| # | Aug 9th 2008, 05:43 | Howard`` | oh ok |
| # | Aug 9th 2008, 05:43 | AD7six | and it depends what you're doing and how you set it up (indexes!) |
| # | Aug 9th 2008, 05:44 | Howard`` | what would you use for indexes on large databases? an auto_increment field, a username, or a uuid? |
| # | Aug 9th 2008, 05:44 | Howard`` | I noticed virtual worlds tend to do the uuid |
| # | Aug 9th 2008, 05:45 | AD7six | well it doesn't matter so long as it's unique and can/will never change (don't use a username). uuids are useful to share info across dbs. i.e. allowing slaves to accept registrations to later sync with the master (if there is one) and other slaves. |
| # | Aug 9th 2008, 05:46 | Howard`` | would sync occur on a cron or immediately? |
| # | Aug 9th 2008, 05:47 | AD7six | Howard``: I'm giving you examples and you're asking about app logic |
| # | Aug 9th 2008, 05:47 | AD7six | also I pointed out indexes and you asked about primary keys - indexes aren't primary keys |
| # | Aug 9th 2008, 05:47 | Howard`` | sorry i'm just a little bit over my head, trying to make sense of it all, databases aren't my strong suit |