From: | Andres Olarte <olarte(dot)andres(at)gmail(dot)com> |
---|---|
To: | Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>, pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: How to bulk load a schema using JDBC multiple times? |
Date: | 2005-10-18 23:33:59 |
Message-ID: | 3fccaa690510181633t7fc02e2fh762e5362fb9f0973@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Hi,
Yes, but how? I tried to create a stored procedure with all of the
commands. I tried creating a table in a special schema, storing the
schema in that table, and executing commands off that table. They
have all failed due to quote problems. Any other ideas?
On 10/18/05, Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov> wrote:
> Have you considered having your test suite create a template
> database, and using it to drop and create the test database?
>
> >>> Andres Olarte <olarte(dot)andres(at)gmail(dot)com> >>>
> Hi,
>
> I need to load and drop my schema multiple times during my unit tests.
> This happens several thousand times per run of my test suite. I'm
> loading the schema from the file that's generated by pg_dump, and it
> works, but it's SLOW. My tests are taking more than 10 minutes now,
> and most of the time is spent loading the schema. If there away to do
> this faster? May be using a store procedure with the whole schema?
> I've tried making such a procedure, but it doesn't work do to quoting
> problems. Anybody have any ideas? Thanks
>
> Andres
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Andres Olarte | 2005-10-18 23:42:57 | Re: newbie jdbc3 tiny example |
Previous Message | andy petrella | 2005-10-18 22:45:24 | Array ??? |