Search results

Ok I have a solution. QNAP has problem with samba. You can install your own samba controller in container and it works very fast. So finnaly it's possible to use QNAP but better option is to buy server with Windows Server where aren't any problems.

I find interesting thing in QNAP. When I tick "oplock" in SMB properties it works very fast. So the problem is when it was disabled. QNAP has problem with sharing files with that option disabled.

No. I program in PHP with frameworks and .NET.

I add week number and year to get it work faster. Where is it possible I use this two than date but I can't use it in all reports. Here is about 80% tables. This table Umowy has 70 columns and 30 000 records, but the biggest tables is Tabela splat and NotaOdsetkowa (each about 1 500 000...

I think I have some problem because I created it about 10 years ago for the temporary program but it works till now. I create a lot of new functionality and there ale a lot of changes in company so I know some problems but without create all new program I didnt have idę to optymalize that. I...

It's not possible to store it in one table. There are a lot of tables where data is very important and i must choose information from this table to one raport. I made a lot of improvements, but it hard because there are a lot of important data in one raport. This system is like bank credits...

I will check it but in my opinion it's not problem with memory because all PC in my opinion is quite power. Ryzen 5650 with about 16GB DDR4 memory 3200MHz. When it works with windows server it's a lot of faster (x10). Windows server has only one ethernet port 1GB. New QNAP has 2 ports 2.5G and...

Of course all users has their own copy localy on Windows 10 Pro. So there is 6 frontend and shared backend databases (7 databases, because i split big databases separetly to speed it). Two years ago I have another idea. Buy Windows Server with shared windows on them. In this case everything...

I try this another idea. I mount iscsi to Windows Server 2012 and share this disk to another users. It seems that i get about 30 secounds.

Ok i try this. Thanks I use QTS Hero with ZFS. System is on 10TB Raid and SSD M.2 as cache read/write. Disk read is about 3430MB/s and write 2600MB/s. I can also change it and reinstall system on SSD without cache. Also 32GB of ram in my opinion is ok with this database size. I think I need...

Hi, I have quite big database in MS Access and has some problems. Introdution: I have 7 databases backend (.accdb) located in shared folder in Windows Server 2012. Each database is about 80-200MB. From this databases i created one frontend. Some tables has about 1 500 000 records. It's problem...

Hi, I'm Martin and I made quite big system in ms access. Slpit databases with frontednd and backend and about 6 databases with milon of records. I'm happy to see this forum because I have similar problems as one thread (corruption databases) and try find how to use QNAP serwer with the database...