Register now or log in to join your professional community.
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 ?) ?
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.
