0
The answer to this question really depends on the data base engine (that is the server software) being used to store the information. If, for instance, you are using MS SQL as the engine, it will naturally write all it's information into a SQL file, or the engine will be used to write into a stand-alone SQLLite file (where no actual server software is running).
In any case, most database engines will write to their own native files to help minimize read/write times. This is because CSV files are both a blessing and a curse. They are universal ASCII Comma Separated Value files that can be read by anything - even Notepad. This makes them easily transferrable from any system to another. However, they pretty much have to be read AND written to in SEQUENTIAL order. In a database containing a few thousand records, that could be a long Update execution time.
In summary, it is extremely faster for a database engine to use it's native file format. However, CSV's are mainly for import/export purposes and transferring data from one system to another.
Wiki User
∙ 11y ago
Add your answer:
Earn +20 pts
How do you read or open sqlite files?
SQLite files can be read by downloading an SQLite database application. You can visit SQLite's download page to download an appropriate package for Windows, Linux, or Mac OSX to read and modify SQLite files. Normally, you will not need such an application, as SQLite is often embedded into another application, such as a web browser. In this case, opening the file directly is not advised, since damaging the SQLite file will render its contents inaccessible to the application that uses that file.
What are typical access rights that may be granted or denied to a particular user for a particular file?
Read, write, execute, and functions in software objects.
What is meant by read and write txt in file handling?
read: moving data from file to memory write: moving data from memory to file
What file systems does Ubuntu support?
Ubuntu supports a large number of file systems, including ext2 (read/write), ext3 (read/write), ext4 (read/write), ReiserFS (read/write), JFS (read/write), XFS (read/write), FAT (read/write), and NTFS (read, additional software available for writing). With the exception of NTFS, it can also boot off of the above file systems.
How do you read and write video file in java?
you can use inputstream for reading the file java.io.fileinputstream and write the file using outputstream..
What abilities does the NTFS write permission grant?
Write to the file, append to the file, and read or change its attributes.
How can you read and write to files in C programming language?
We can read and write to files with the help of file commands in c programming.There are so many commands related to file for read,write,append,delete etc.
Write java program to merge alternate lines from file1 and file2 into file1?
I suggest something like this:* Open file1 and file2 * Create a temporary output file, for writing * Read a line from file1, write it into the output file * Read a line from file2, write it into the output file * Repeat the previous two steps, while you are not at end-of-file in either of the two files * At this point, if you are NOT at end-of-file in file1, read the remaining lines of file1, and write them to the output (you can write a loop for this). * Similarly, if you are NOT at end-of-file in file2, read and write the remaining file. * Close file1, file2, and the output file. * Copy the temporary output file back to file1 * Erase the temporary output file
Write a PHP program to read and write a text file?
Oh this is easy =PLets say or file is "file.txt"
What are the permissions of a new text file?
Read,Write and Execution permissions. r- Read w- Write x- Execution
How do you change a read only file into a read write file?
To change a read only file into a read write file, first find the file to be edited. Then right click the file and click on properties. Next, click the general tab and clear the read only check box. Lastly, click on the OK button.
How you can delete the data in the file when you open the file in read or write mode in C programming?
When you open a file in write mode, eg. fp=fopen("filename.txt","w"); the content of the file is deleted.
