topic Re: retrieving dir struct. very slow trough windows explorer in Alfresco Archive

retrieving dir struct. very slow trough windows explorer

henk — Mon, 21 Jan 2008 13:52:57 GMT

Whenever I access my Alfresco Server trough the windows explorer / mapped share it goes very slow…How to solve this? Because it takes like 7 seconds to fully load a directory with 1000 files or so.Already tested network connectivity *which is fine (100mbit)Hardware of the Server is also fine *(which

Re: retrieving dir struct. very slow trough windows explorer

mikeh — Mon, 21 Jan 2008 15:37:02 GMT

Windows Explorer really doesn't scale well when viewing more than a few hundred files.

Is there any way you can split your files into folders?

Thanks,
Mike

Re: retrieving dir struct. very slow trough windows explorer

henk — Mon, 28 Jan 2008 08:43:06 GMT

shouldnt it just function correctly by showing the files immediatly?

Re: retrieving dir struct. very slow trough windows explorer

mikeh — Mon, 28 Jan 2008 09:28:01 GMT

shouldnt it just function correctly by showing the files immediatly?

That would be nice, but unfortunately Microsoft didn't code it that way!

Mike

Re: retrieving dir struct. very slow trough windows explorer

henk — Mon, 28 Jan 2008 09:35:50 GMT

If I am right this is the CIFS server being "slow" right ????

Re: retrieving dir struct. very slow trough windows explorer

mikeh — Mon, 28 Jan 2008 10:56:51 GMT

There are two "slowdown" effects here:

1 - Yes, the CIFS server is slower than a "native" network drive, simply because there's more going on than a bog-standard file system (i.e. the Alfresco repository). It's also dependent on the performance of your database server and it's filesystem.

2 - Windows Explorer really doesn't scale well over a few hundred files over a network. Try browsing a "normal" network folder share containing 1000 files and you'll see the problem.

Thanks,
Mike

Re: retrieving dir struct. very slow trough windows explorer

henk — Mon, 28 Jan 2008 14:02:25 GMT

Well it seems the MySQL database is maybe also slowing it down.
Is there anything faster then MySQL or is there some way of tuning it for Alfresco ?

The database is hosted on the same server as where alfresco is hosted on.

Re: retrieving dir struct. very slow trough windows explorer

jcblitz — Fri, 04 Apr 2008 19:07:53 GMT

Well it seems the MySQL database is maybe also slowing it down.
Is there anything faster then MySQL or is there some way of tuning it for Alfresco ?

The database is hosted on the same server as where alfresco is hosted on.

What did you do to determine MySQL might be slowing it down?