May be I am wrong,
But I guess you have not used stored procedures?
If speed and performance is important along with scalability, then
forget database independence and use stored procedurs.
I have built a small function called execProc() which I can send you off
the list.
It just makes use of t
On Dec 18, 2011, at 5:53 PM, rivka wrote:
> So - actually investigated it thoroughly - and here are the results:
>
> My database size on disk is 362MB and includes the main table and
> multiple one to many associated tables. I am querying the main table
> (which has little info in itself - mainl
So - actually investigated it thoroughly - and here are the results:
My database size on disk is 362MB and includes the main table and
multiple one to many associated tables. I am querying the main table
(which has little info in itself - mainly id, an integer value and a
string value (mostly less