|
by: Guru |
last post by:
Hi All
I am using a Global Temporary table in the Stored procedure and i am
creating index for a column in that temporary table.When i am executing
it. It is not taking that index. I checked using explain plan. But if i
run the runstats in the CLP for that temporary table it is taking the
index. How i have to implement in the Stored procedure itself?
Warm Regards
Guru
|
by: VM |
last post by:
Why is the third line of code in the loop take so long? W/o that line, the
execution (35,000 loops) runs in 3 secs. With the line, it goes up to over 5
mins.
dataGrid_auditAddress.DataSource = null;
for(int i=0;i<table_rowNums.Rows.Count; i++)
{
iRowNum = Convert.ToInt32(table_rowNums.Rows); //this
table has all row numbers that will be modified
DataRow row_1 = DT_tempTable.Select("col_row = " +
|
by: paulwilliamsonremove |
last post by:
Hi,
Using Access 2003.
I am trying to delete records from one table/query
("qryHistoryPersonIDs") if they don't exist in another table
("qryDonations"). But the SQL syntax I came up with is taking forever
or locking up Access 2003.
What am I doing wrong?
|
by: Ike |
last post by:
Why would some innodb's not take a 'no null' for a field? Has anyone
experienced anything like this? -Ike
|
by: Nate Baxley |
last post by:
OK, I'm taking my first stab at a custom error handler. Here's what
I've got but it takes a very long time to return. If I remove the die
command it reutrns much faster, but then I get several error messages
when I only want one. Any ideas?
Nate Baxley
function ErrorHandler($code, $msg, $file, $line) {
?><h1>Something wrong has happened</h1>
<?
|
|
by: CarrieR |
last post by:
I am working within a DB I have been devolping in Access 2003, and have encountered a report coding issue I was hoping someone could help me with:
I have 18 reports, each running off some smaller queried version of 2 main queries (apx. 6000 records each). The purposes of the DB and the reports require the formatting of these reports to change monthly as Actual Revenue is reported.
I can accomplish all of these monthly formatting changes...
|
by: KiranKGone |
last post by:
Hi All,
We have a requirement to archive ( delete and store on a tape device ) the transaction data which is more than 90 days old. Have written the export commands, followed by the delete commands for all the transaction tables. However, I have a table in which 90% of the data is LOBs. The export is working fine on all the tables ( though slower for LOB table ), however, delete is taking some hours for LOB table, in order to delete a few...
|
by: resmi318 |
last post by:
I am running a query similar to given below.
CREATE TABLE ABC_08
AS
(SELECT x.col1,
trim(x.col2),
x.col3,
x.col4,
x.col5
FROM Table1 x
|
by: Kumarswamy |
last post by:
Hi,
I have a problem, i have used one condition in where clause .....
but it is taking some time to return values.......
so my procedure is taking lot of time.......
for the same table if i query with another column in where clause within fraction of second i getting values.......
This query is taking some time......
SELECT entrykey,uniquekey FROM frt_app.ENTRIES_WES WHERE uniquekey=9422077251
|
by: kavin |
last post by:
our Customer used to take export backup of a particular schema,
previously it used to finish within 30 Minutes. As of now it is taking
almost 12 Hours.
Export is consuming more time while taking the backup of three
particular tables.This tables contains row sizes of 15 lakhs,one lakhs,
75 lakhs respectively
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
|