InfoQube IM - Community

Submitted by David_H on 2009/05/04 02:38

I run several programs that use databases on our small network with no issues. However if I place my IQ file on a mapped network drive, it's so slow as to be unusable. Do I need to do a different type of install to use it on a network? This is ofr my personal file, so I am the only user that access it.

Thanks

Comments

IQ is still in beta and does need a fast LAN (100mbit/sec min) to work well. This will be improved as there are plans to use remote SQL Server as a back-end which will require more "efficient" data management.

What aspects are particularly slow (navigating in the grid, HTML pane)? If all panes are closed, is the performance adequate?

Using a database is not in itself a factor. Are these other programs true multi-user? Non-multi-user database engines (such as SQLite) can read all data in memory and simply write changes. Multi-user apps must track changes by other users, support record locking, etc.

You may want to compact the IQBase.

Yes, the other programs are true multi-user. Network is 100 megabits. The performance is unrelated to number of panes open, the problem occurs even if only one is open. To give you an idea of speed, the lag is so bad it's unusable. Clicking on an item might take 10 seconds for the info in the HTML pane to appear. Same for trying to create a new item so it's not just related to the HTML pane. I have compacted ans repaired with no luck, it's also a very small database (under 10 megabytes). Any other suggestions? Are there any firewall exceptions I should add? I'm certainly not saying IQ is the cause, it could be some other issue causing this.

OK, as I suspected I was able to trace it down to a network issue, fixed.

Great! Can you share with us what the issue was and how it was solved?