Hi I Just started of with SOCI and i was hoping you experts could help me out
I have a oracle DB with intially one million entries , and i wanted to load
them all in one container so i came up with two methods The first one
was using vectors and the other method was using rowset .. My question is at
the end
Method 1: Vectors
----------------------
Now when I was populating the vectors with One million entries after the
exexcution of the SQL it took exactly 6 seconds for the program to display the
next line
so i conclude that it takes 6 seconds to populate the vectors..vector<string>
id(count);
vector<string> fnames(count);
vector<string> lnames(count);
sql << "select * from employees", into(id), into(fnames),into(lnames);
cout << "Takes 6 seconds to populate the 3 vectors with one million entries";
}
Methd 2: Rowset
--------------------
When i used the rowset to to execute the query the it took 0 seconds
and then to display the contents i use an iterator and traverse through the
rowset
now my question is
1) does the rowset container gets completely populated so quickly ?? why the
huge huge difference??
2)How else can i display the entire contents of my table other than using
vectors and rowset ?? any example available ??
3)Suppose there are 10 million entries in my DB what would be the fastest way
to lad them up ???
------------------------------------------------------------------------------
Nokia and AT&T present the 2010 Calling All Innovators-North America contest
Create new apps & games for the Nokia N8 for consumers in U.S. and Canada
$10 million total in prizes - $4M cash, 500 devices, nearly $6M in marketing
Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store
http://p.sf.net/sfu/nokia-dev2dev
_______________________________________________
Soci-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/soci-users
