Received: by 10.50.76.133 with SMTP id k5mr97003igw.2.1333139329451;
        Fri, 30 Mar 2012 13:28:49 -0700 (PDT)
X-BeenThere: h2-database@googlegroups.com
Received: by 10.50.56.204 with SMTP id c12ls2540798igq.2.canary; Fri, 30 Mar
 2012 13:28:46 -0700 (PDT)
Received: by 10.50.187.202 with SMTP id fu10mr87134igc.5.1333139326780;
        Fri, 30 Mar 2012 13:28:46 -0700 (PDT)
Received: by 10.50.187.202 with SMTP id fu10mr87133igc.5.1333139326772;
        Fri, 30 Mar 2012 13:28:46 -0700 (PDT)
Return-Path: <noelgran...@gmail.com>
Received: from mail-iy0-f181.google.com (mail-iy0-f181.google.com [209.85.210.181])
        by gmr-mx.google.com with ESMTPS id em8si837134igc.2.2012.03.30.13.28.46
        (version=TLSv1/SSLv3 cipher=OTHER);
        Fri, 30 Mar 2012 13:28:46 -0700 (PDT)
Received-SPF: pass (google.com: domain of noelgran...@gmail.com designates 209.85.210.181 as permitted sender) client-ip=209.85.210.181;
Authentication-Results: gmr-mx.google.com; spf=pass (google.com: domain of noelgran...@gmail.com designates 209.85.210.181 as permitted sender) smtp.mail=noelgran...@gmail.com; dkim=pass header...@gmail.com
Received: by mail-iy0-f181.google.com with SMTP id o28so1644982iao.12
        for <h2-database@googlegroups.com>; Fri, 30 Mar 2012 13:28:46 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20120113;
        h=mime-version:in-reply-to:references:from:date:message-id:subject:to
         :content-type;
        bh=GuJGdfwWgt8fU+4uvhhyLyvMhPKM1Mk4tTVjajkcWSU=;
        b=H23BbjuETLqfANpnXTDDPxe9ZuMov8/x36CgS9cMzgGnewqzhk9EeUaOgzBs0teaB1
         QUyEBCJF3CUOPG4vjWGn0I830X1Dh2Lgvxq9cljJrG6TfSd9Fa5NVLlEKS1T9kISDcIB
         /sv2xSynji3ccFe+LVnm4i58j7BpZmPaBohblmx0U+kdagKZfzYmMSKV1RVYM7vo71MI
         +17e1gwZujzNS8oszDopAXMQPLVAAoMpbaYBLhyI8EAk8ecFn+Cuze8ytgGucyzsce+z
         7+6GH9hbBVcfR3QY9SoAxhodCl9/fqrCRdjOtdA3G1WkTdr1WUNhwkiHNl7j6K+d8Jgk
         34iw==
Received: by 10.43.49.199 with SMTP id vb7mr2141547icb.9.1333139326173; Fri,
 30 Mar 2012 13:28:46 -0700 (PDT)
MIME-Version: 1.0
Received: by 10.42.167.199 with HTTP; Fri, 30 Mar 2012 13:28:05 -0700 (PDT)
In-Reply-To: <1047545.485.1333131209119.JavaMail.geo-discussion-forums@vbbp15>
References: <1047545.485.1333131209119.JavaMail.geo-discussion-forums@vbbp15>
From: Noel Grandin <noelgran...@gmail.com>
Date: Fri, 30 Mar 2012 22:28:05 +0200
Message-ID: <CAFYHVnW-QhbZxfYnEko2t6wRO11XAug6jM1Litwif9pwYZ6...@mail.gmail.com>
Subject: Re: is there a tutorial anywhere on how to use prepared statements
 with H2 ?
To: h2-database@googlegroups.com
Content-Type: text/plain; charset=ISO-8859-1

google for "jdbc preparedstatement"

On Fri, Mar 30, 2012 at 20:13, Christian MICHON
<christian.mic...@gmail.com> wrote:
> Hi,
>
> I've now been using H2 for almost a year, extremely happy about its ease of
> use and performances.
>
> I'm currently trying to import lot of data into several tables, using always
> similar insert commands.
>
> I read somewhere that prepared statements could help speeding up partially
> (I've already experienced the usal no log, no undo and cache hints). I've
> been looking in many places, and I could only find a few java source files,
> but no tutorial, no concrete example.
>
> Where could I find some?
>
> Thanks again for this very nice tool.
>
> Regards,
> Christian
>
> --
> You received this message because you are subscribed to the Google Groups
> "H2 Database" group.
> To view this discussion on the web visit
> https://groups.google.com/d/msg/h2-database/-/Pv6T6eatQCoJ.
> To post to this group, send email to h2-database@googlegroups.com.
> To unsubscribe from this group, send email to
> h2-database+unsubscribe@googlegroups.com.
> For more options, visit this group at
> http://groups.google.com/group/h2-database?hl=en.