ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.

متابعة

How many gigabyte equal 1 billion characters ? and what is the best way to search in it ?

So , if i have one record into MySQL database and the data Type for this record is LONGBLOB or LONGTEXT and as we know the maximum length for this data types is4,294,967,295 characters ! if i transfer this length to a storage in KB then to GB , How much this record can take from my hard disk if i fill it with data to the end ? More Clear : if i have a database for My Country "Egypt" with90 million people , and every one of them record his info and some other data like school and visa card info and so on .. in10 table , every table consist of10 column and every column Contains100 characters ! - can any body tell me how much gigabyte this database equal ? and what is the best method can i use to make searching in it (select or find or what ?) ?

user-image
تم إضافة السؤال من قبل Sameh Khaleifa , Senior Web Developer , BNS Business Solution
تاريخ النشر: 2014/07/08
Prospero Sevilla
من قبل Prospero Sevilla , IT Generalist , Abu Zaid & El Essawi Group

900 Gigabytes. The Select method is faster because you will only  need to extract the record you need from the server.  Unlike the Find method in which you need to extract all the whole data from the server into the client before you can execute the Find method.  The advantage of find method, however, is once all the data were already downloaded, finding specific record will be faster.

 

المزيد من الأسئلة المماثلة