Subject | Re: [IBDI] Re: Internet |
---|---|
Author | Peter Morris |
Post date | 2001-06-06T10:18:49Z |
I did some benchmark tests on MS ACCESS, IB, MYSQL and Advantage
Advantage was by far the quickest to insert records (probably the least
frequent action) but absolutely by far the slowest (by a magnitude) when
selecting a FIELD LIKE '%MORRIS%'. Even slower than access.
That was the end of my testing on Advantage :-)
For those of you who are curious the results on the select where
1) MySQL
2) IB
3) Access
4) My grandmother looking up words in a dictionary :-)
5) Advantage
I will bring the results in from home at lunch time if anyone is interested
?
Pete
Advantage was by far the quickest to insert records (probably the least
frequent action) but absolutely by far the slowest (by a magnitude) when
selecting a FIELD LIKE '%MORRIS%'. Even slower than access.
That was the end of my testing on Advantage :-)
For those of you who are curious the results on the select where
1) MySQL
2) IB
3) Access
4) My grandmother looking up words in a dictionary :-)
5) Advantage
I will bring the results in from home at lunch time if anyone is interested
?
Pete