HEAP does not support TEXT columns... Too bad.

Gaspard
2007/9/14, Gaspard Bucher <gaspard / teti.ch>:
> I could more then double the speed of my tests by avoiding fixtures
> reload on each test and using transactions. Have a look at
> http://dev.zenadmin.org/browser/trunk/test/test_helper.rb and
> http://dev.zenadmin.org/browser/trunk/test/zena_test.rb.
>
> It sure helped me (and I will now try Travis' HEAP idea on top of that).
>
> Gaspard
>
> 2007/9/14, Travis D Warlick Jr <warlickt / operissystems.com>:
> > -----BEGIN PGP SIGNED MESSAGE-----
> > Hash: SHA1
> >
> > kevin cline wrote:
> > > My RAILS unit tests take approximately one minute to run.  This may
> > > not sound like much, but it's a real drag on incremental development.
> > > I imagine most of the slowness in spent in applying the database
> > > schema to the test database.  Is there a memory-resident database that
> > > would speed up my tests?
> >
> > You can use Heap tables with MySQL if you wish.  This SQL statement will convert
> > a table into a Heap (memory-resident) table:
> >
> >   ALTER TABLE tablename TYPE=HEAP;
> > -----BEGIN PGP SIGNATURE-----
> > Version: GnuPG v1.4.7 (MingW32)
> > Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
> >
> > iD8DBQFG6cnYWvapaOIz2YYRAuuvAJ4wwlypxThIaHCkVy7t4V1iDdgEHQCfZ5w+
> > wYBYFf9cGzqs56/O04qhG9I=
> > =JLqS
> > -----END PGP SIGNATURE-----
> >
> >
>