IRC Networks
Irc Logs Stats
Start date: 2007-09-27 02:48:27
Last update: 2008-10-24 20:19:38
Channels: 41
Logged Lines: 6230436
Size: 1822.24 MB
Powered by
Channel Info
Network: freenodeChannel: #csharp |
Search in www.irclog.org
Log from #csharp at freenode 2006-07-05
[16:46]<fyfuym-syfggag>well waiting for a spec on the php project
[16:47]<fyfuym-syfggag>that the dude was writing in 10 minutes
[16:47]<fyfuym-syfggag>been 30 now
[16:47]<mjzdmdgo|busd>30 minute spec?
[16:48]<mjzdmdgo|busd>riiiiiighhht....
[16:48]<azyfm>30 minute spec
[16:48]<azyfm>that's not waterfall, at least
[16:48]<azyfm>more like raindrop
[16:48]<fyfuym-syfggag>Moridin8|Busy: scroll up
[16:48]<mjzdmdgo|busd>nah..
[16:48]<fyfuym-syfggag>he said he was going to write a spec in 10 minutes
[16:49]<fyfuym-syfggag>I tuned yar
[16:49]<fyfuym-syfggag>wtf you gonna write in 10 minutes? how to make a project fail?
[16:49]<mjzdmdgo|busd>pretty much 'It's a project that does XYZ. I need a A and B and C.' is about it...
[16:49]<mjzdmdgo|busd>big wow
[16:50]<sdnffdxdlld>at least you get a spec
[16:50]<mjzdmdgo|busd>grumlbes?
[16:50]<sdnffdxdlld>grumbles
[16:50]<fyfuym-syfggag>smellyhippy: I have had dealing with this person
[16:50]<fyfuym-syfggag>he write 1 a4
[16:51]<sdnffdxdlld>I dont have a spec at work :S
[16:51]<fyfuym-syfggag>smellyhippy: but you spec yourself
[16:51]<fyfuym-syfggag>and your pj prob does his work correctlyu
[16:51]<sdnffdxdlld>pj?
[16:51]<sdnffdxdlld>and how can i spec if i dont have a spec :P
[16:51]<fyfuym-syfggag>project manager
[16:52]<sdnffdxdlld>nope no project manager ... just a lead dev
[16:52]<fyfuym-syfggag>ah
[16:52]<fyfuym-syfggag>he knows his shit
[16:52]<mjzdmdgo|busd>smippy: yeh, but you were given a brief and told to make it work in a company that has no real ORM or DAL experience.
[16:52]<mjzdmdgo|busd>and by the sounds of it, no time to spec it up yourself
[16:53]<fyfuym-syfggag>I get 15 minute briefs
[16:53]<sdnffdxdlld>I was told to make a DAl ... no specs for min/max bandwidth ... no specs for max objects ... no specs for the db's
[16:53]<sdnffdxdlld>but when i have to make big changes because i find out things i dont get the blame so its ok
[16:54]<mjzdmdgo|busd>deadline?
[16:54]<mjzdmdgo|busd>Doco?
[16:54]<mjzdmdgo|busd>testing?
[16:54]<mjzdmdgo|busd>peer review?
[16:54]<mjzdmdgo|busd>...
[16:54]<mjzdmdgo|busd>...
[16:54]<sdnffdxdlld>working alpha of the 3 apps by october iirc
[16:54]<mjzdmdgo|busd>not so bad then ;)
[16:55]<sdnffdxdlld>the db is going to be way larger than anything i've worked on before :S
[16:55]<sdnffdxdlld>righty back to work
[16:55]<sdnffdxdlld>bbiam
[16:56]<mjzdmdgo|busd>bigger than all the ones we both worked on in total?
[16:56]<sdnffdxdlld>maybe ... i havent got a full feel for it yet
[16:56]<sdnffdxdlld>theres lots of complexity in how it handles verything
[16:56]<sdnffdxdlld>*gone*
[17:21]<mjzdmdgo|busd>hmm.... need some industrial music...
[17:23]<mjzdmdgo|busd>\m/(>_<)\m/
[17:29]<sdnffdxdlld>now I think I've found a major memory leak in sql server
[17:29]<sdnffdxdlld>cries too
[17:32]<sdnffdxdlld>unless the SMO stuff is supposed to use hundreds of meg of ram for looping through the list of stored procs :(
[17:32]<sdnffdxdlld>and it doesnt release it when i quit the app
[17:32]<mjzdmdgo|busd>erm....
[17:32]<mjzdmdgo|busd>no.
[17:32]<mjzdmdgo|busd>thats... um... not right...
[17:33]<mjzdmdgo|busd>what you trying to do?
[17:33]<mjzdmdgo|busd>uh.. nite kog <--- was he even here?
[17:33]<kjr>hiding.
[17:34]<mjzdmdgo|busd>uh
[17:34]<mjzdmdgo|busd>k
[17:34]<sdnffdxdlld>foreach (StoredProcedure storedProc in sqlServer.Databases[con.Database].StoredProcedures)
[17:34]<sdnffdxdlld> {
[17:34]<sdnffdxdlld> if (storedProc.AssemblyName == sqlAssName)
[17:34]<sdnffdxdlld> {
[17:34]<sdnffdxdlld> storedProcsToDrop.Add(storedProc);
[17:34]<sdnffdxdlld> }
[17:34]<sdnffdxdlld> }
[17:34]<sdnffdxdlld>opps :/
[17:34]<sdnffdxdlld>that was ment for IE X(
[17:36]<mjzdmdgo|busd>smippy: run a cursor over this result set in an SP... select name from dbo.sysobjects where xtype = N'P' and status>0
[17:36]<sdnffdxdlld>it's sitting at 71meg till i run that code ... then it goes up to 450meg+ before I kill sql server to regain my comp
[17:36]<mjzdmdgo|busd>(obviously constrain as needed)
[17:36]<sdnffdxdlld>but thats not the point!
[17:36]<sdnffdxdlld>the smo stuff is supposed to work
[17:36]<mjzdmdgo|busd>'supposed to'
[17:36]<sdnffdxdlld>i'm supposed to be able to compleatly do it from c#
[17:37]<azyfm>Moridin8|Busy - SMO does more or less the same
[17:37]<sdnffdxdlld>grrrrrrrrrrr
[17:37]<azyfm>I've looked at SMO in SQL Profiler
[17:37]<sdnffdxdlld>more or less but with a huge memory leak :P
[17:37]<mjzdmdgo|busd>Arild: I know, but direct SP is quicker.
[17:37]<azyfm>maybe you should break out SQL Profiler too, smellyhippy?
[17:37]<sdnffdxdlld>just doing that :)
[17:38]<azyfm>there's also a method on the Server object, where you can set which properties on the various SMO objects are eagerly fetched
[17:39]<azyfm>could help
[17:42]<sdnffdxdlld>yeah but ram usage going from 76meg to 400+?
[17:42]<sdnffdxdlld>for looping through the stored procs and stroing them in a List<>?
[17:43]<azyfm>which process is going to hell? sql server or your app?
[17:43]<sdnffdxdlld>sql server
[17:43]<sdnffdxdlld>thats the messedu p thing
[17:43]<sdnffdxdlld>I could understand if it was my app X(
[17:43]<sdnffdxdlld>but imagine if this was a live server!
[17:44]<mjzdmdgo|busd>smippy: http://pastebin.ca/79551
[17:44]<cgrdns>I need to get some information on dynamically adding URLs to my web application... Anyone have something I can look up?
[17:45]<sdnffdxdlld>thanks dude ... I'm gonna do some investigation on this first so maybe i can kick ms into fixing it ... it could possibly the reason behind the deploy problems too
[17:45]<mjzdmdgo|busd>http://pastebin.ca/79553 (forgot a unicode prefix on the select)
[17:47]<mjzdmdgo|busd>I'd throw that into a CLR SP with some real STRICT code level security...







