| Author |
Topic |
|
Lumbago
Norsk Yak Master
3271 Posts |
 Posted - 2009-01-19 : 07:48:29
|
...when I, after 2 weeks in my new job, I discover that the 3GB-soon-to-be-150GB database that I'll be 100% responsible for is based on an EAV model and a simple search for a customer involves a view with a 10-table deep join??  - Lumbago |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-01-19 : 07:53:42
|
Yes. Have a beer too... 
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-01-19 : 08:05:20
|
And have a look at indexed views for your own sanity.
E 12°55'05.63"N 56°04'39.26" |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2009-01-19 : 08:16:09
|
| or change it to XML EAV!but honestly your setup that will never work well.___________________________________________________________________________Causing trouble since 1980Blog: http://weblogs.sqlteam.com/mladenpSpeed up SSMS development: www.ssmstoolspack.com <- version 1.1 out! |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-01-19 : 08:22:11
|
Come to my place and have a barbecue!
E 12°55'05.63"N 56°04'39.26" |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2009-01-19 : 08:24:53
|
Well...luckily it's not all EAV, but a lot of it is. I didn't mention that it's a 3rd party tool with 999 tables (yes, ninehundredandninetynine) but now you know. I'll be sure to mention XML EAV to the provider when I get the chance  - Lumbago |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-01-19 : 08:29:04
|
Which application are you talking about?
E 12°55'05.63"N 56°04'39.26" |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2009-01-19 : 08:32:34
|
| I don't want to mock them in public since I'll be working quite closely with them in the future...but I'll PM it to you. Maybe you even know them!!- Lumbago |
|
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2009-01-19 : 08:36:28
|
quote:
Originally posted by Lumbago
Well...luckily it's not all EAV, but a lot of it is. I didn't mention that it's a 3rd party tool with 999 tables (yes, ninehundredandninetynine) but now you know. I'll be sure to mention XML EAV to the provider when I get the chance - Lumbago
Hmmmm. The number of the Beast + half the number of the beast. Suspicious. Your new boss isn't Al Pacino by any chance?Charlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2009-01-19 : 09:17:39
|
| Hmmm...last time I check my boss had fled the country. Let me check again and get back to you - Lumbago |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-01-19 : 09:59:15
|
quote:
Originally posted by Peso
Come to my place and have a barbecue!
Can we use the server as fuel? It would be merciful considering what's going to be running on it.--Gail ShawSQL Server MVP |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2009-01-19 : 12:01:25
|
quote:
Originally posted by Lumbago
I don't want to mock them in public since I'll be working quite closely with them in the future...but I'll PM it to you. Maybe you even know them!!- Lumbago
Go ahead and tell.They're probably clueless enough to actually be proud of the EAV design.CODO ERGO SUM |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
Am I allowed to cry...