meta user
network profile
| bio | website | |
|---|---|---|
| location | Augsburg, Germany | |
| age | 18 | |
| visits | member for | 8 months |
| seen | May 7 at 13:18 | |
| stats | profile views | 9 |
. : .. : ..: .. ::: ::. :: :
|
Mar 23 |
awarded | Nice Question |
|
Dec 16 |
comment |
Improve the performance and stability of a MySQL server Never heard of vanilla or Percona or Maria. After a short search i guess these are kind of mods for MySQL-Server? A Engine like INNODB? But Percona also provides a DB-Service. Can i outsource my DB to them and they will support and optimize? |
|
Dec 15 |
comment |
Improve the performance and stability of a MySQL server Thanks Bryan. Well i think our indexes are fine, but buffer size is a topic which i will try. |
|
Dec 14 |
asked | Improve the performance and stability of a MySQL server |
|
Dec 7 |
comment |
restricting users to rows they created Yes that's correct. By default remote access to the MySQL database server is disabled. And i think on free webhosts, you cant even change it anyway. |
|
Dec 7 |
accepted | Tablestructure for fast inserts/deletes with foreign keys |
|
Dec 7 |
comment |
Tablestructure for fast inserts/deletes with foreign keys Thanks. Yeah GROUP_CONCAT goes in the right direction. I guess there is no other solution to get such a multi dimensional array? |
|
Dec 7 |
comment |
Tablestructure for fast inserts/deletes with foreign keys Ahh now i see why you asked for "why this array?". Your query works nice, but the output is not like i expected. I will need it like the example array. Otherwise my application can not handle it easaly. |
|
Dec 7 |
comment |
Tablestructure for fast inserts/deletes with foreign keys Thanks a lot. Query works like i expected. Ruud van de Beeten posted similar. Both works. Only Problem i got, which is not very handy for my application, is that for every copmetitor there will be a single row. So the product_identifier is redundant, which he should not. I think i will need the result, like i posted under "my goal". Is this possible? |
|
Dec 7 |
awarded | Commentator |
|
Dec 7 |
comment |
Tablestructure for fast inserts/deletes with foreign keys Thanks ;) With the array i just wanted to show what my output should look like, for better understanding. I will make two test tabels and heck this out, if it works like i expected it and come back and tell how it worked out. So far thanks and i will vote up. |
|
Dec 7 |
comment |
Tablestructure for fast inserts/deletes with foreign keys Thank you. I also updaed, the question, because i think my overall topic got a little bit lost. I added the goals to see what my real question is about. But thanks for this infos, i think i will also need them. |
|
Dec 7 |
revised |
Tablestructure for fast inserts/deletes with foreign keys added goals |
|
Dec 7 |
comment |
Tablestructure for fast inserts/deletes with foreign keys Well there is no foreign key relationship between this two tables yet. c.product has an index, but no foreign key. |
|
Dec 7 |
comment |
Tablestructure for fast inserts/deletes with foreign keys So when i delete in p a product, every row in c gets also deleted where the product_identifier is the same? I only have to define the c.product as CASCADE? Ok, sounds great.
But how about the query to do this. What kind of join do i need? Looks to me, that this is no a kind of default join, because i came from the other table. |
|
Dec 7 |
answered | restricting users to rows they created |
|
Dec 7 |
revised |
Tablestructure for fast inserts/deletes with foreign keys added example |
|
Dec 6 |
revised |
Tablestructure for fast inserts/deletes with foreign keys expand |
|
Dec 6 |
revised |
Tablestructure for fast inserts/deletes with foreign keys deleted unimportant |
|
Dec 5 |
revised |
Tablestructure for fast inserts/deletes with foreign keys edited table names mor likely |
