Re: Slow retrieval from DB

Joseph Burneff wrote:

> Hello,
>
> I'm using the MySQL++ to place strings into an array.
> The database has about 100K records. It takes about
> 2-3 minutes to access the database and put all the
> strings into the array. The database server is MySQL.
> The machine is an Intel Celeron with 128 MB of RAM
> with a 100BaseT connection. My code is shown below:
>
> // Inputs data from table "strings" through a remote
> DB connection
> char** GetData(int &dataCnt) {
>  char** data;
>
>  dataCnt = 0;
>  Connection con(use_exceptions); 
>  con.connect("test", "home", "teddy", "bear");  
>  Query query = con.query(); 
>  query << "select * from strings"; 
>  Result res = query.store(); 
>  
>  Row row; 
>  data = new char*[res.size()];
>  Result::iterator i;  
>  for (i = res.begin(); i != res.end(); i++) { 
>    row = *i; 
>    data[dataCnt] = new char[strlen(row[0])];
>    strcpy(data[dataCnt], row[0]); 
>    dataCnt++; 
>  }
>  return data;
> }
>
> Is this length of time to be expected for database
> access with the API or is there a faster way to code
> this?  
>
> Thanks,
>
> Joe
>  

A speed that you get is expected.

You have lot's of unnecessary code.

As you have stored all data , memory is already allocated and so your 
code with :

.. new char[strlen...
strcpy
etc ...

is just wasting memory and CPU.

--

Sincerely,

--
For technical support contracts, go to https://order.mysql.com/?ref=msmi
  __  ___     ___ ____  __
 /  |/  /_ __/ __/ __ \/ /    Mr. Sinisa Milivojevic <sinisa@xxxxxxxxx>
/ /|_/ / // /\ \/ /_/ / /__   MySQL AB
/_/  /_/\_, /___/\___\_\___/   Full time Developer and Support Coordinator
      <___/   www.mysql.com   Larnaca, Cyprus



--
MySQL++ Mailing List
For list archives: http://lists.mysql.com/plusplus
To unsubscribe:    
http://lists.mysql.com/plusplus?unsub=gcdmc-plusplus@xxxxxxxxxxx