Databases
StackOverflow2013
Postsdbo
POJDBC with MySQL really slow, don't know why
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POJDBC with MySQL really slow, don't know why
    primarykey
    data
    text
    <p>I have a problem with a really slow connection between my Java code and a MySQL Database. I don't know where the bottle neck is.</p> <p>My program is more or less a chatbot. The user types something in, my program splits the sentence into words and sends it word per word to the database. If it finds something there, the user gets an output. The database is on an external Server, but I also tried to connect to a pc next to me. Both is slow. </p> <p>I tried the connection once at another place then where I normally work and there it was fast, most of the time.</p> <p>My SQL Code:</p> <blockquote> <p>SELECT info.INFORMATION FROM INFORMATION info, INFO_SCHLUESSEL sch<br> WHERE LCASE(sch.SCHLUESSELWORT) LIKE '" + input + "%' AND info.ID_INFO = sch.ID_INFO<br> Order BY info.PRIORITAET DESC LIMIT 1;</p> </blockquote> <p>(just remembered, if it helps to understand the sql code:<br> schluessel = key<br> Schluesselwort = key word<br> prioritaet = priority)</p> <p>My Java Database Code is more or less standard stuff:</p> <blockquote> <p>String driver = "com.mysql.jdbc.Driver";<br> String dbase = "jdbc:mysql://bla";<br> String dbuser = "bla";<br> String dbpw = "bla"; </p> <p>Class.forName(driver);<br> Connection con = DriverManager.getConnection(dbase, dbuser, dbpw);<br> Statement stmt = con.createStatement(); </p> <p>ResultSet rs = stmt.executeQuery(query);<br> while (rs.next())<br> {<br> ergebnis = rs.getString("info.INFORMATION");<br> } </p> <p>rs.close();<br> stmt.close();<br> con.close(); </p> </blockquote> <p>edit: </p> <p>I have tried this DBCP for a while now, and I can't seem to get it to work. It seems to be as slow as the old connection. This is the example provided by the website that I use:</p> <blockquote> <p>GenericObjectPool connectionPool = new GenericObjectPool(null);<br> ConnectionFactory connectionFactory = new DriverManagerConnectionFactory("jdbc:mysql://bla", "bla", "bla");<br> PoolableConnectionFactory poolableConnectionFactory = new PoolableConnectionFactory(connectionFactory,connectionPool,null,null,false,true);<br> PoolingDriver driver = new PoolingDriver();<br> driver.registerPool("example",connectionPool);<br> Connection conn = DriverManager.getConnection("jdbc:apache:commons:dbcp:example"); </p> </blockquote>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    plurals
    1. This table or related slice is empty.
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POJDBC with MySQL really slow, don't know why
      1. USChris Kentfield
      1. VTFavorite
    1. COAre you using a connection pool?
      singulars
      1. POJDBC with MySQL really slow, don't know why
      1. USThilo
    2. CONo, not yet. But I will look into it now.
      singulars
      1. POJDBC with MySQL really slow, don't know why
      1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload