[ic] Database design questions

[Steve & Patti Getzinger]

I presently run a site with the Bible in .gdbm with no problems. I could
further enhance speed with Glimpse but see  no real reason to at this
point. By the way the Bible is equivalent to just over 32,000 products. I
also run another gdbm on the same site with 1500 entries.

Steve

"Bob Puff@NLE" wrote:

> I have two questions regarding IC's database:
>
> 1. Is there any major reason that the default .gdbm files won't work for
> a small to mid-sized site?  It is a performance issue?  When is it
> necessary to use something like MYSQL?
>
> 2. I've noticed that in the admin interface of "construct", when you
> delete an order, it really isn't deleted from the transactions database.
>  I would think this file would get to be huge after a while.  Is there
> some sort of auto-pruning that removes the deleted orders?
>
> Bob
>
> _______________________________________________
> Interchange-users mailing list
> Interchange-users@lists.akopia.com
> http://lists.akopia.com/mailman/listinfo/interchange-users