On Wed, 2004-10-27 at 11:37, Edward Beuerlein wrote:
> I have used ACID in the past and once you get too large of a database
> the sql queries take more than 180 seconds to complete and ACID is
> useless. In BASE have you fixed any of the sql queries as most of
> them were poorly written in ACID?
> -Eddie B.
How big do you consider too large? We are currently working on tuning
the SQL as part of our conversion. I would appreciate any help you
could give us in judging the performance of BASE. For example, if you
didn't mind, you could send me an export of your database and I could
import it into a test system here for larger queries.
BASE Project Lead
The next step in IDS analysis!
On Thu, 2004-10-28 at 10:20, Edward Beuerlein wrote:
> When it approaches a million records in the database, ACID begins to run=20
> horrible slow-anything over a million and access time tanks hard.=20
> Unfortunately due to the sensitivity of the data I can't give you a=20
> export of my database. I was just curious to know if you had done any=20
> fixing to ACID to remedy this issue.
> -Eddie B.
Thanks for the information. I am copying the development team on this
email. We will look into streamlining the queries to speed things up
for everyone. =20
Please let us know if there is anything else we can do or add.
Get latest updates about Open Source Projects, Conferences and News.