String.Substring is very slow and floods garbage collector

[GoogleCodeExporter]

What steps will reproduce the problem?
1. Execute some long queries or create table statements while profiling the 
memory and notice that it is extreme bloat
2.
3.

What is the expected output? What do you see instead?
In my examples I am loading a database file that is ~50kb extremely small file. 
Just doing and select * from ... on all the tables i end up using ~5mb of 
memory that is nearly 100 times larger than the actual size of the database.

Sure there is overhead but calling Substring while parsing a long query is 
going to create n-1 new strings. The C code uses simple pointer arithmetic to 
no copy the data so much. Is it possible to use char[] and indexes instead of 
string.substring? 

What version of the product are you using? On what operating system?
3.7

Please provide any additional information below.

I absolutely love the framework but would love for it to be lighter. We are 
using it with Unity and it works great thanks.

Original issue reported on code.google.com by chwiela...@gmail.com on 8 Feb 2014 at 5:13

[GoogleCodeExporter]

I will investigate this, and see what can be done.

Original comment by uygar.raf@gmail.com on 17 Feb 2014 at 3:03

[GoogleCodeExporter]

Original comment by uygar.raf@gmail.com on 24 Oct 2014 at 2:10

• Changed state: Assigned

[GoogleCodeExporter]

Original comment by uygar.raf@gmail.com on 24 Oct 2014 at 3:53

• Changed state: Started