Hi Toni,
Have you tried jdbc native driver ? It's really faster.
Xavier
[EMAIL PROTECTED] wrote :
> Following test case returns insert times of 80-130ms (on average
> 110ms). What am I doing wrong here? Why is the insert so slow? I'm
> using the jdbc-nested-0.33.jar.
>
> public class Test
> {
> public static void main(String[] args)
> {
> Test test = new Test();
> }
>
> public Test()
> {
> try
> {
> Class.forName("org.sqlite.JDBC");
>
> Connection database =
> DriverManager.getConnection("jdbc:sqlite:test.db");
>
> database.setAutoCommit(false);
>
> Statement statement = database.createStatement();
> statement.executeUpdate
> (
> "CREATE TABLE IF NOT EXISTS messages ("
> + "id INTEGER PRIMARY KEY AUTOINCREMENT UNIQUE,"
> + "timestamp DATE NOT NULL,"
> + "data TEXT NOT NULL);"
> );
>
> statement.close();
>
> PreparedStatement preparedStatement =
> database.prepareStatement
> (
> "INSERT INTO messages "
> + "(timestamp, data) VALUES (?, ?);"
> );
> preparedStatement.setDate(1, new Date(new
> java.util.Date().getTime()));
> preparedStatement.setBytes(2, "<?xml version=\"1.0\"
> encoding=UTF-8?><row>1</row>\r\n".getBytes());
>
> long debugStartTime = new java.util.Date().getTime();
>
> int result = preparedStatement.executeUpdate();
> database.commit();
>
> long debugEndTime = new java.util.Date().getTime();
>
> System.out.println("Insert time: " + (debugEndTime -
> debugStartTime) + " ms");
>
> preparedStatement.close();
>
> database.close();
> }
> catch (Exception e)
> {
> e.printStackTrace();
> }
> }
> }
>
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"SQLiteJDBC" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlitejdbc?hl=en
-~----------~----~----~----~------~----~------~--~---
