I had not really given much thought to the server-side includes. They have always worked. I did some research though and found that SSI is essentially a separate interpreter. The order of whether SSI is included inside PHP or vise-versa matters (apparently depending on your version of PHP). I also found that comment begin and end tags are more strict after I made my updates.

While I know it is bad form, commenting out a "div" as shown above worked prior to the PHP update. After the update, the text "

I am trying to update the PHP on my web server. On my backup server I updated from 5.2 to 5.4 and the result is kind of bizarre.

The includes above worked correctly prior to the update. This is what I see when viewing the page source in my browser:

After the update I see this:

The bizarre part is that the includes get injected seemingly at random further down the page and in the middle of source that is generated by PHP code. Is there a DOCTYPE or PHP configuration setting that needs to be changed?

Thanx, >>>-----> Mike

Thanks for the response. I did find and try some meta tags suggested on other forums. The X-UA-Compatible that I found set content equal IE7, but it did not fix the problem. What finally worked was to use page-break-before instead of page-break-after. The results should have been identical for either style code, but they were dramatically different in IE10.

-- Mike

I have created a page that displays label data in a 3xN array suitable for printing on Avery 5160 labels. A form feed, "&#12", is placed after each group of 30 labels. I tried using CSS "page-break-after: always", but it did not work as expected. For multiple pages worth of data, when printed or print previewed in IE8 and FF, the position and spacing of the 10 rows of labels on each page is constant. In IE10 the position of the first row is constant but the spacing between the first and second row of labels narrows on each page after the first page. This can be seen in the print preview and on the printed pages. The space between all of the other rows is still constant. Does anyone know an HTML or CSS tweak that might fix this?

Thanx, >>>-----> MikeO

If anyone is interested, I found a solution to this problem on another forum. The connection string I am using has the server IP address to avoid any DNS issues. Apparently this is not good enough. I had to place an entry for the server in the hosts table of the client machine. Once this was done the time it takes to connect to the server drops back into the milliseconds range.

Thanx, >>>-----> MikeO

Further review of the SQL profile shows this: Main program opens database connection (SPID 55) ...3 sec... Events processing thread opens database connection (SPID 56) ...3 sec... [PROCESS NEXT EVENT] Event processing thread does aggregate query (SPID 56) Audit login occurs (SPID XX) (XX usually between 57 and 60) ...3 sec... SET NO_BROWSABLE_TABLE_ON (SPID XX) sp_prepare 'select * from tblData' (SPID XX) SET NO_BROWSABLE_TABLE_OFF (SPID XX) sp_unprepare (SPID XX) Audit logoff occurs (SPID XX) Event processing thread does aggregate query on tblData (SPID 56) Audit login occurs (SPID XX) (XX usually between 57 and 60) ...3 sec... SET NO_BROWSABLE_TABLE_ON (SPID XX) sp_prepare 'select * from tblData' (SPID XX) SET NO_BROWSABLE_TABLE_OFF (SPID XX) sp_unprepare (SPID XX) Audit logoff occurs (SPID XX) Event processing thread does non-aggregate query on tblData (SPID 56) Event processing thread calls stored procedure (SPID 56) Event processing thread does non-aggregate query on tblData (SPID 56) [LOOP: PROCESS NEXT EVENT] I have never run SQL profiler before. From what I have seen I have to guess that either these 'Audit Logins' were not occurring two weeks ago or opening database connections was not taking as long two weeks ago. Can anybody run SQL profiler and give me an idea how long opening a connection normally takes?

Thanx, >>>-----> MikeO

If you have the management studio available just right click on the object you want to script. In 2000 you select All Tasks -> Generate SQL script. In 2005 it is slightly different but just as easy to accomplish.

Thanx, >>>-----> MikeO

What I am trying to do is find out why a query that used to take 10ms is now taking 3 seconds to return a record set. I was hoping that dropping and then creating the table again might fix whatever had changed. There are only about 7000 records in the table most of the time, so a query should not take that long. I have followed up on this thread with a new question: A-tale-of-two-queries[^] If you have any insight on 'Audit Login' I would appreciate hearing about it.

Thanx, >>>-----> MikeO

Looking at the SQL Profiler on the SQL server I see that each time the second query is called it is followed by an 'Audit Login'. There is always a delay between the query and the 'Audit Login' and apparently my app does not receive a record set until after this is completed. Any ideas what could be causing this?

Thanx, >>>-----> MikeO

modified on Wednesday, May 26, 2010 8:03 AM

David, I have done this per your suggestion to an earlier inquiry. There are no scans. It executes as quickly as I would expect in the Management Studio.

Thanx, >>>-----> MikeO

Not sure where the temporary storage would take place. I have executed the query on the server. There is no noticeable delay. And that is puzzling because both the query sent by the code and the query typed into the Management Studio are executed on the server.

Thanx, >>>-----> MikeO

Going to try asking this a different way and see if anyone can help. I have two queries:

SELECT * FROM tblData WHERE Machine = 1 and Operator = 1

and

SELECT SUM(WorkSecs) as WorkTime, SUM(RunSecs) as RunTime
FROM tblData WHERE Machine = 1 and Operator = 1

Both of these queries are in a custom application I wrote that has been in operation for about four years. Both queries were taking only milliseconds to return a record. Some time last week the second query started taking about three seconds to return a record. The owner of the SQL server admits to mucking about with data table, so I have DROPPED the data table and CREATED it again. I have also backed up the database and truncated the transaction logs (though I don't think it would have any effect on this). The second query is still taking about three seconds to execute. The custom application is written in C++ using ADO and trusted connection. There are no ODBC/DSN connections defined on the client computer. Can anyone think of anything I can check on the SQL server or the client?

Thanx, >>>-----> MikeO

modified on Wednesday, May 26, 2010 10:16 AM

I have created scripts for the indexes and triggers. The list of dependents is quite long though, so I don't want to create too much of a mess. Thank you for running the test. I should have thought of that.

Thanx, >>>-----> MikeO

The question is will I have to drop and create each view again?

Thanx, >>>-----> MikeO

Thanks for the helpful suggestions. It turns out my observations were flawed. The CFile::Remove is working correctly. The data processing has slowed to a crawl and it appeared that the files accumulating was the cause. Instead it is the result. Have posted a query in the Database forum now. Thanks again.

Thanx, >>>-----> MikeO

If I drop / create a table in MSSQL 2005 will all of the dependent views still work?

Thanx, >>>-----> MikeO

I followed the steps in your reply. Nothing looks to be wrong with the query. It even appears to execute normally in Management Studio. When I execute it in the code on the client though it takes about three seconds. The client app has been running successfully for about four years. Now it is getting bogged down by two queries. Both do field sums. Any ideas what could change on a server or connection that would slow down a SUM operation? This is a close approximation of the query that is taking so long: SELECT SUM(WorkSecs) as WorkTime, SUM(RunSecs) as RunTime FROM tblData WHERE Machine = 1 and Operator = 1

Thanx, >>>-----> MikeO

A query that used to take milliseconds is now taking 3 seconds to run The table only has 7000 records and I rebuilt the one index that it uses I am thinking if I drop/create the table the problem may get fixed, but the table has several dependent views, etc. Will each dependent item need to be created again?

Thanx, >>>-----> MikeO

Perhaps you should read my posts. The data in the file is read into memory before I attempt to delete the file. I am trying to get help diagnosing why a long running program would fail without modifying the code. Since the read/delete/process occur in that order within the try/catch and the data is being processed, I know that CFile::Remove is not throwing an exception. Is there an error condition of DeleteFile() for which CFile::Remove would not throw an exception?

Thanx, >>>-----> MikeO

I was explaining how I know that no exception is being thrown. If CFile::Remove were throwing an exception the data would not be processed. The data is being processed but the files are not being removed. This causes the file processing loop to take longer each time and eventually the program fails. I'm looking for clues why CFile::Remove might not be working and not throwing an exception. The program has been working for five years. This is why I asked about Windows updates.

Thanx, >>>-----> MikeO