MemoryTest.java

/*-
 * #%L
 * JSQLParser library
 * %%
 * Copyright (C) 2004 - 2019 JSQLParser
 * %%
 * Dual licensed under GNU LGPL 2.1 or Apache License 2.0
 * #L%
 */
package net.sf.jsqlparser.statement.select;

import java.io.StringReader;
import net.sf.jsqlparser.parser.CCJSqlParserManager;
import net.sf.jsqlparser.statement.Statement;

public class MemoryTest {

    public static void main(String[] args) throws Exception {
        System.gc();
        System.out.println(Runtime.getRuntime().totalMemory() - Runtime.getRuntime().freeMemory());
        CCJSqlParserManager parserManager = new CCJSqlParserManager();

        String longQuery = "select * from k where ID > 4";

        /*
         * String longQuery =
         * "select  *  from  (  SELECT  intermediate.id  as  id  ,  intermediate.date  as          "
         * +
         * "date  FROM  (  SELECT  DISTINCT   (  id  )   FROM  (  SELECT                           "
         * +
         * "wct_workflows.workflow_id  as  id  ,  wct_transaction.date  as  date  FROM             "
         * +
         * "wct_audit_entry  ,  wct_transaction  ,  wct_workflows  WHERE                           "
         * +
         * "(  wct_audit_entry.privilege  =  'W'  or  wct_audit_entry.privilege  =                 "
         * + "'C'  ))))";
         */
        /*
         * String longQuery = "select  *  from  d WHERE                           " +
         * "(  wct_audit_entry.privilege  =  'W'  or  wct_audit_entry.privilege  =                 "
         * +
         * "'C'  )  and  wct_audit_entry.outcome  =  't'  and                                      "
         * +
         * "wct_audit_entry.transaction_id  =  wct_transaction.transaction_id  and                 "
         * +
         * "wct_transaction.user_id  = 164 and  wct_audit_entry.object_id  =                       "
         * + "wct_workflows.active_version_id ";
         */
        StringReader stringReader = new StringReader(longQuery);
        Statement statement = parserManager.parse(stringReader);
        // stringReader = new StringReader(longQuery);
        // Statement statement2 = parserManager.parse(stringReader);
        // stringReader = null;
        // statement2 = null;
        statement = null;
        parserManager = null;
        longQuery = null;
        System.gc();
        System.out.println(Runtime.getRuntime().totalMemory() - Runtime.getRuntime().freeMemory());

    }
}