http://www.programmersheaven.com/feed/User/343300/RSS.aspx Events at Programmer's Heaven related to the user exile_9999. en Copyright 2013 Programmers Heaven Sun, 19 May 2013 21:51:49 -0700 Argotic Syndication Framework 2007.3.0.1, http://www.codeplex.com/Argotic http://www.rssboard.org/rss-specification 360 <p>Posted a 'new message on the Algorithms forum.</p>Hello! I am a beginner programmer. I have a problem with the runtime of one of my applications. <br /> <br /> I have a website application that tries to compute for recommended objects to users. The recommended results is based on the user as well as the currently viewed object.<br /> <br /> My problem is, I have 500 artworks and almost 30 users. What I do is, for each user, I compute the value for recommendation for EACH artwork. So that means, for 1 object, I compare ALL of the other objects to it. Then after the computation, I store it in the Database. So for each user, I have around 250000 records inside the Database.<br /> <br /> Can I have any tips regarding on how to optimize it? Either some changes to the Database model or some changes to the code. I have 3 FOR loops (1 for user, 1 for viewed object, 1 for target objects). I have already tried using UNION ALL, but the INSERT statements doesn't seem to be the case.<br /> <br /> Help please!<br /> <br /> Sat, 01 Aug 2009 18:32:23 -0700 <p>Posted a 'new message on the Database & SQL forum.</p>Hello! I am a beginner programmer. I have a problem with the runtime of one of my applications. <br /> <br /> I have a website application that tries to compute for recommended objects to users. The recommended results is based on the user as well as the currently viewed object.<br /> <br /> My problem is, I have 500 artworks and almost 30 users. What I do is, for each user, I compute the value for recommendation for EACH artwork. So that means, for 1 object, I compare ALL of the other objects to it. Then after the computation, I store it in the Database. So for each user, I have around 250000 records inside the Database.<br /> <br /> Can I have any tips regarding on how to optimize it? Either some changes to the Database model or some changes to the code. I have 3 FOR loops (1 for user, 1 for viewed object, 1 for target objects). I have already tried using UNION ALL, but the INSERT statements doesn't seem to be the case.<br /> <br /> Help please!<br /> <br /> Sat, 01 Aug 2009 18:30:24 -0700