95 reputation
9
bio website
location Augsburg, Germany
age 20
visits member for 2 years, 1 month
seen Jan 18 at 14:23

. : .. : ..: .. ::: ::. :: :


Sep
24
awarded  Autobiographer
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