Re: Migrate from MySQL to PostgreSQL

Mensaje citado por Andreas Korthaus <akorthaus@web.de>: > > However > > if you dont use the datatype abstraction than MDB is actually > > slightly faster than DB, mainly because I could do some changes to > > MDB based on the experiences that were made in the development of DB. > > Hm, I don't need datatype-abstraction, because I only use "standard > datatypes" as int, smallint, char, varchar and text. I know that I loose a > lot of cool DB-Features, but DB Abstraction is more important for me, and to > use unix-timestamp in INT-fields is really fast an nice to handle in PHP. > Flags don't to be real bolean, could be smallint or char. Perhaps it is not > nice, but it works everywhere. 1) Not using DATE, TIME and TIMESTAMP fields makes you miss functions related to does time fields. 2) If you use a boolean you can have faster selects like this one: SELECT * FROM tabname WHERE boolfield This is optimized in the database server, and it should be faster then having a TINYINT(1) with an index on it (bad MySQL implementation of boolean data type). -- select 'mmarques' || '@' || 'unl.edu.ar' AS email; ------------------------------------------------------- Martín Marqués | Programador, DBA Centro de Telemática | Administrador Universidad Nacional del Litoral -------------------------------------------------------