- May 1, 2005
I'm hoping there's some experienced programmers in here. What I'm asking is if I was to create a website and used PHP to develop a text file based database then would there be any limitations or disadvantages compared to creating a SQL database? I already know that PHP locks files out while a script is accessing it. There should be some work arounds for this but for the time being I need to determine if I could have a website which could expand indefinately by using only text files and images. The files would be arranged by file name and a directory structure so I'm also wondering if scripts had to navigate down into a deep directory tree would that slow things down much? Has anyone actually experimented with speeds of accessing files in directories?