Featured Ligji Anti-shpifje dhe shteti rrumpalle!

MySQL

MySQL

SQL vs noSQL

on 09/08/2010
There is an interesting discussion around on wether we should stick by the old Relational Databases or go with the new hype of noSQL. noSQL looks very interesting in the fact that it does not use as much resources as...Read More
MySQL

MySQL Remove Duplicates

on 12/17/2009
A quick method to remove duplicate records from your database: ALTER IGNORE TABLE tablename ADD UNIQUE INDEX dublicatedindex (fieldthatcontaindoubles); ALTER TABLE tablename DROP INDEX dublicatedindex The method above will remove dublicates and will add a Unique key to the field...Read More
InfoarkivaMySQLWebi Shqip

MySQL Database Replication

on 09/21/2009
Replication Kur nje projekt arrin nje fare volumi informacioni, vihet re qe nuk eshte me e lehte te administrohet databaza e tij. Ne rastin tone, Projekti i Infoarkives, (http://lajme.shqiperia.com), kaloi mbi 2.1 Giga informacion. Per kete projekt ne kishim vendosur...Read More