Re: midcom.services.at
Torben Nehmer <[email protected]>
| Newsgroups | gmane.comp.web.midgard.devel |
|---|---|
| Message-ID | <[email protected]> |
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hi,
- --Torben Nehmer wrote on 2006-02-06 13:30:
> TODO (if you want to stay in core code):
> [...]
Two more things:
> CREATE TABLE midcom_services_at_entry_db (
> [...]
> PRIMARY KEY (id),
> KEY oocmsgreceipt_sitegroup_idx(sitegroup)
>);
a) The key naming is broken. All components in the main midcom CVS use the
semantics {$table_name}_{$index_name} for naming indexes to avoid namespace clashes.
b) Consider adding a furthe index over the start column to speed up queries.
Live long and Prosper!
Torben Nehmer
- --
Torben Nehmer, Guenzburg, Bavaria, Germany
http://www.nathan-syntronics.de, mailto:[email protected]
PGP Public Key: https://www.link-m.de/pgp/t.nehmer.asc
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.0 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
iD8DBQFD50X5JPh4Kn6d5FYRArHHAJ9hVbykaXHyOQS6fEw3Uts/JTU8ogCdE1mg
5QYP1ro3ZKrmIiJUEtupvDY=
=sZQW
-----END PGP SIGNATURE-----