Search Result

This is more about guidance than a question I think.

We have some off site developers/consultants writing reports off a cube they developed and were supposed to be managing. They keep getting this error and are requesting we up their memory to 12G.

'System.OutOfMe moryException'

We did to quiet the noise for the moment but, that takes away from other systems, namely my test servers, and I am wondering...

I have a stored procedure which is being used on an online form.

In the form the user is able to ask for records based on an Age. So 5 days old, 2 days old, etc. The age is based on the date that the record was entered or received. So we have JobReceiveDate.


The stored procedure was written like this. Where @Ageto and @AgeFrom come from the online form.

...

I'm running application on Windows Mobile device.

The device I use to test the application is Symbol Motorola MC75.

When deploy the application on the device I see that the application loading slowly to go to main screen.

The application using a lot line of code. Is there any way I can make the application go to main screen much faster?

Hi Friends,
I need to implement parallel and dependent downstream system population. Here my doubts is about approach whether i've to go with windows service or exe which will be run through SQL job.

What is the good achivements will get using the approach.
performance is the key to me.

Please suggest me ASAP.

thanks in advance to all for the suggestions and who is going to reply ...

Hej,

We 're working on an application that displays a lot of data, we have some problems with the memory usage (displaying data in grid, see some linked data, ...) when closing the grid the memory usage does not drop, but when we call the Garbage collector in the disposed event. The memory drops phenomenal.

this is code we execute.
...

Hi all, working in Access 2003 (using the Access 2000 file format).

I've been developing a moderate-sized database and have recently secured write permission for the network folder that is to be its permanent home. So after moving it there, I went to split the front and back ends so that I could test the links, distribute the front end, and begin training the administrators.

But it hasn't gone well.

Previously,...

All,
I have reviewed a lot of posts but can't seem to find the answer to this one:

I have a SQL 05 Enterprise server linked to an Oracle 10g Server to retrieve records from Oracle table (300K rows). The query is a simple select * from tbl openquery. (I know the implications of using * in a query, but bare with me through the explanation...)

1. Initially utilized the MSDAORA provider to link SQL to ORACLE:
Response...

Prior to today I had a fairly large database, split into front end and back end, the back end residing on a 2-bay Dlink NAS we use as a file server, running in RAID, connected through an old 16 port hub running at 100mbits. Roughly 5-10 users have the front end on their PC and are in the database at the same time.

The problem was the database was very slow moving through records, opening forms, everything was just very sluggish....

Hi,

We are using DB2 UDB 9.5 FP2a.
And the following SQL is not using the right index.

SELECT a1.col1, a0.col2
FROM TABLE1 a0 INNER JOIN TABLE2 a1 ON a0.KEY1
= a1.KEY1
WHERE ((a0.number_01 = '00001985014082 ') AND (a0.number_02 = '001'))

There are indexes on number_01 and number_02 columns.

We have done RUNSTATS on the tables.
The TABLE1 has -...

Hi,

I am extracting data from an operational system in order to maintain a mirror that can be used for reporting.

I have two means of filling this database:

1) A stored procedure which truncates all tables and rebuilds everything from scratch. This takes about an hour and will be run periodically.

2) A stored procedure that updates my database with the previous days activity which will be...

This question is about DB2 table design and performance.

We are using DB2 UDB Enterprise 8.2 on Linux.

We have 6 tables in a parent-child (one-to-many) relationship with each other. Each child table having an FK up to its parent. This particular design is motivated by our domain model.

A -> B -> C -> D -> E -> F

There is some debate in our team about how best to accomplish...

In terms of processing speed, what is the best method for displaying tabular data from a database in a Windows forms C# app? We generally use data grids (Infragistics WinGrid), but have an instance where run-time performance MUST be optimal - coding complexity and other things are less important. Here are some paticulars:
1. Data is stored in SQL Server.
2. Data is read-only.
3. The container/control must allow for mouse-click...

Given a complex web site with a zillion of files, most of them including (or requiring) files, a ton of functions...
... is there a simple way to measure performance and find the slow functions (or blocks of code)?

Obviously I can add code to call time() at the beginning and end of each function, and subtract. But considering the number of functions that would take a very long time.

Is there something built in the...

in MySQL queries, which one is more performance optimized between IN and OR operators.