|
I am getting the same problem, any suggestions would be very much appreciated.
|
|
|
|
|
We had a similar problem a while ago with crystal 8.5. From the research we did we found the following (to the best of my understanding). It seems when you open the report it loads all the data into an array in memory. You initially get a very large increase in the resources used (about a meg for the viewer object and other objects if you use charts etc and the rest for the data for the first report, This in your case is about 18 meg). When you close the form the viewer object is destroyed but the array is not(you should see a small drop in allocated memory). The next time you run a report it again creates the viewer object adding a few more meg. The data is loaded into the already existing array. If the data is more than before the array will grow. If it is less it all fits into the existing array and NO changes are made to the size. The array is destroyed when you close your application.
As our application was running on a terminal server we found out about the problem very quickly (clients server died if several people ran reports). With crystal the problem is made all the worst by the fact it will load ALL the data into the array then work on any critera you have set, so it may load 3 linked tables in their entirety yet only display 2% of the records if that all that fits the selection criterea.
Rather than upgrade and risk running into the same issues we just switched to Active Reports by DataDynamics which are XML layout based and have a tiny memory footprint.
So, sorry to say but i think if you want to use crystal you are stuck with this.
Jon
|
|
|
|
|
Thanks for your reply. I am not tied into sticking with crystal reports, but after looking on DataDynamics website, it would cost us $10k for a site license of active reports.
DO you know of any cheaper alternatives?
|
|
|
|
|
Sorry but no. There are only 2 of us developing here and one of the things we really wanted to do was give the end users the ability to alter the reports. The crystal report designer component licence is more restrictive and would result in us having to substantially increase to cost of our software. The DataDynamics one is royalty free so for us it was actually a far cheaper option than crystal anyway.
Jon
|
|
|
|
|
 hello i am a beginer. i want to program on a PDA to identify chinese medicine. i need to setup a database to store all the info about chinese medicine. how to store both text and pictures inside and can i use chinese characters?
|
|
|
|
|
tudou wrote:
can i use chinese characters
I would have thought so.
tudou wrote:
how to store both text and pictures inside
If you don't know how to store text, then you need to buy a basic book on databases, or read the help that came with your database.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
Hello,
I'm programming an application for a multi user environment, so multiple users will work with different applications on the same database tables.
Now, here's my problem.
Lets say user A en user B start the application, and there local dataset is filled. Let's say user A changes row 1, automatically the application will save this in the application and in the database. But now user B doesn't have this latest info yet.
How do i solve this?
Nowadays it's working like this, each minute the application is getting the latest info from the database, and the datagrid is redrawn with the new latest info.
but i would like to compare the current dataset for changes with the new dataset from the database. Is there an easy way to do this?
thx
|
|
|
|
|
There's nothing you can do about what is shown on one clients screen while another is changing it, unless you lock records so only one person can have them at a time. I'd lock only when you get to a point of editing, and then users will find out someone beat them to it if they try to edit something that someone else has grabbed. The 1 minute refresh is basically a race condition, and a drain on your database server resources.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
I have created one site and want to upload it .but i do not now how to restore the database to the server.if i can do this only by using enteprize manager .if yes i do not now how to enter the server!for example i can copy the web pages of the site in the www.root ,i can copy the database to the wwwroot too.but can not restore it.The problem is i do not now how to access to the programs(such as enteprize manager)in the server?
|
|
|
|
|
Anonymous wrote:
i can copy the database to the wwwroot too.but can not restore it
I answered a very similar question a few hours ago. You can find it on this forum here[^]
Anonymous wrote:
The problem is i do not now how to access to the programs(such as enteprize manager)in the server?
If you need to access programs in general on the server then you can use Remote Desktop Connection (assuming the administrator of the server permits in-bound connections and your account has permission to be accessed remotely in this way), it is in your Start --> All Programs --> Accessories --> Communications menu.
My: Blog | Photos
WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More
|
|
|
|
|
I am trying to create a deployment project for my windows app using the MSDE deployment toolkit so my database and SQL will be automatically configured on client machines. The only information i have to work with is an article at http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnmsde/html/msdedepl.asp[^]
I was wondering if anyone could help me out with the code and or sql statements for actually creating the database, tables, login info, etc. I dont know that much about SQL or SQL statements. I have written a complete app using a SQL database and it works great i just need help with my deployment using the MSDE toolkit because that looks like the best way to go for ease of installation. If anyone has any input, code, just any kind of help with this, i would greatly appreciate it. Thank you.
|
|
|
|
|
Can I create a table for a *.mdb file with a sql statement (crate table{}) in asp.Thanks for your help from now
enigma
|
|
|
|
|
i've developed an application that uses ADO.NET.
If want to distribuite it do i need to save in the user installation diretory some dll or other files?
Thanks
|
|
|
|
|
|
how is it possible to distribuite an application about 500 kb to force the final user to install all the .NET framework.
It is a very bad nonsense!!!!
Is there someone more serious can answer?
|
|
|
|
|
Sasuko wrote:
how is it possible to distribuite an application about 500 kb to force the final user to install all the .NET framework.
Easy, if they don't install the .NET framework the application doesn't work. So if they want it to work they must download the .NET Framework.
Sasuko wrote:
It is a very bad nonsense!!!!
23Mb these days is not a lot for a download. Most JVMs are of a similar size.
Sasuko wrote:
Is there someone more serious can answer?
My answer was was serious. I suggest you just didn't like it and don't want to accept it.
Remember that the .NET Framework only has to be installed once for all .NET applications on the machine so if they already have it then they don't need to download it again.
My: Blog | Photos
WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More
|
|
|
|
|
as colin replied, there is no nonsense in installing the framework if your program was coded in a .NET language.
do you only know what you do when you compile and when you execute a .NET language ?
if you didn't want so much task to do for your customer, you had to do it in MFC or Win32 or VB6 for example...
TOXCCT >>> GEII power
[toxcct][VisualCalc]
|
|
|
|
|
so the user need to install the framework .NET also if he has windows XP or just for the others older WINDOWS 32 OS?
|
|
|
|
|
no, of course he does need to install something that is already installed...
in fact, you will have to test into your installer if the framework already exist, and if not, propose to install it...
TOXCCT >>> GEII power
[toxcct][VisualCalc]
|
|
|
|
|
so Windows XP user have got by default .NET on their pc?
How can i test in my installer?
|
|
|
|
|
Sasuko wrote:
so Windows XP user have got by default .NET on their pc?
No, Currently only Windows Sever 2003 ships with the .NET Framework.
Sasuko wrote:
How can i test in my installer?
If I remember correctly, if you built your installer using a setup project in Visual Studio then it tests for you because it is set with the details of the components required.
My: Blog | Photos
WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More
|
|
|
|
|
yes but if i create an installer with vstudio it automatically add .NET framework to my setup project?
|
|
|
|
|
|
yes and no...
XP SP1 doesn't, but SP2 provides the framework....
TOXCCT >>> GEII power
[toxcct][VisualCalc]
|
|
|
|
|
So how an i add .NET framework to my setup solution to allow the installation of it for users haven't?
Thanks to both.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
