-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 > Now, I'm thinking about to change pyramid from PHP. I'm using advance > sql query for searching
Give up on that, MySQL is horrible at it - plus, if you're using InnoDB (which you should be) you don't have fulltext searching. If you need to search anything, look into installing a Sphinx server with MySQL integration and configuring to index specific tables and columns that you will be running fulltext searches against. It's what I use for my app and it works extremely well. > When I read pyramid, there is no code to run sql. Pyramid is using > SQLAlchemy. I am not familier with ORM. Can ORM run sql ? How to run > above query in pyramid ? My current database is using MySQL. ORM is just a way of mapping database tables to objects and handling their relationships. Look up "execute()" in the SQLAlchemy docs, that will get you started on running raw queries. Where possible though, use ORM! - -- Parnell "ixmatus" Springmeyer (http://ixmat.us) -----BEGIN PGP SIGNATURE----- Version: GnuPG/MacGPG2 v2.0.17 (Darwin) Comment: GPGTools - http://gpgtools.org iQEcBAEBAgAGBQJN3Se0AAoJEPvtlbpI1POL6k4H/14pyPhy/8lZbdOnAOd3BnpC +MIAiiJpOwTRi/GK6kR0lKjhkH3vstkvr8sioI9vZOAI3XFFznYlP/vOZ509bZKl vdpAcWsZ04udx6Hh/b4nNPPCvzSa+8q3Jgr6u5M8pGfDdSg1tb5JG7CmosldK/ib VSnbaOL9VgwMlviriACa4NSdC2xNJZGssCUmeCiufAvFkwtxc+1HSlewhAx6vBaS afw7dG28m4bm4T+mThAsnZpJyw5oUXEGvla3j4NNWiM/Y2qrHO7Uoss7uOcnMUjk gD8k0HynNzPjvdFNMdkY7I8H+4r4qgvab/XllmGYxDzctwk2B8iOwXJLeJjRd3c= =0kRj -----END PGP SIGNATURE----- -- You received this message because you are subscribed to the Google Groups "pylons-discuss" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/pylons-discuss?hl=en.
