[OPEN-ILS-DEV] Fwd: GSOC [2012] Question regarding PL/SQL & C based stored procedure

[Dan Scott]

Hi Sumit:

(with some apologies for the form-based reply)

On Thu, Apr 5, 2012 at 10:54 AM, sumit verma <sumitverma2013 at 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 <sumitverma2013 at 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 at 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.