Hi Sumit: (with some apologies for the form-based reply)
On Thu, Apr 5, 2012 at 10:54 AM, sumit verma <sumitverma2...@gmail.com> wrote: > Hello everyone, > > I am eagerly Waiting for response from EverGreen. Please give answer to > queries as mentioned in last mail ASAP. > > I want to submit Proposal as the deadline is tomorrow for GSOC 2012. <snip> > ---------- Forwarded message ---------- > From: sumit verma <sumitverma2...@gmail.com> > Date: Wed, Apr 4, 2012 at 3:04 PM > Subject: GSOC [2012] Question regarding PL/SQL & C based stored procedure > To: open-ils-dev@list.georgialibraries.org > > > Hello everyone, > > As I would be interested in this project: > > "Optimize Evergreen: Convert PL/Perl-based PostgreSQL stored procedures to > PL/SQL or PL/C" > > > > So please provide me more details regarding above project, so that i can > decide timelines of projects, followed by mentioning them in proposal that i > want to submit in EverGreen for GSOC 2012. The basics would be: 1) Install Evergreen 2) Build one or more realistic workloads that exercise the database (constrictor might help here) 3) Measure the performance and determine where there are bottlenecks in the database performance 4) Address those bottlenecks - with one approach being to translate non-C stored procedures / database functions to C stored procedures 5) Measure the performance with the translated database stored procedures / functions to determine where improvements have occurred You are the person responsible for working out the details and creating the proposal. If you ask specific questions, we can help with those. If you're having problems installing Evergreen or running it, we can help with that. But if we write your proposal for you, we have no way of knowing if you actually have the ability to do what you / we are proposing for the summer.