|
by: developer |
last post by:
I have the following query that takes anywhere from 1 to 3 seconds
to run. I would expect it to run in less than 1/2 a second (and
I really need it to do so). I've added the appropriate indices
and tried EXPLAIN and ANALYZE; but, I'm not getting anywhere.
SELECT message.id
FROM message, message_thread
WHERE message.id = message_thread.message_id
AND message_thread.thread_id = SOME_CONSTANT_NUMBER
|
by: sumi |
last post by:
I am very new to python , I have small query could some one help me.
every time I get a new load i need to do few things like creating some
dir, changing some file contents and moving some files , i would like
to know if i can write a python script to do all these operation .
|
by: Brian Keanie |
last post by:
I Have an existing query based on two tables which performs as it was
intended. I added two fields from a third table and now the query does not
perform. Any ideas as to what might be going on here?
Thanks
|
by: tdmailbox |
last post by:
I set up my code to disable the shift bypass however for certain users
I want to allow them through a button no a form to be able open up the
list of tablies and queries.
Is there a vb command to open up the user interface that lets you view
the list of tables and queries that you would see if you did a shift
bypass?
|
by: comp.lang.php |
last post by:
I am trying to replace within the HTML string $html the following:
With
Where I'm replacing "action=move_image" with "action=<?=
$_REQUEST ?>"
|
|
by: ChaseCox |
last post by:
I have a form that I use to input criteria that I have then being passed into a query. Currently the query saves the results as an excell file. I would also like to have the results show up in the form, I guess as a subform. If this is possible I would love some assitance on this. Thanks to all of you who have helped me so far.
|
by: mirangk |
last post by:
guys i have a query regarding vb i want to convert hexadecimal into ieee(floating point value) and finally display the decimal value using vb so can anyone help me in that pls. i am stuck i am not able to do it
|
by: wugon.net |
last post by:
question: db2 LUW V8 UNION ALL with table function month() have bad
query performance
Env:
db2 LUW V8 + FP14
Problem :
We have history data from 2005/01/01 ~ 2007/05/xx in single big
table,
we try separate this big table into twelve tables and create a view
|
by: mikek12004 |
last post by:
with one query I would something like this
SELECT COUNT(id) AS numrows FROM pelates where owned='112';
to get the number of results and this
SELECT * FROM pelates where owned='122' LIMIT 10,20
to get the subset I need, but now I have a union of 4 selects and I want the count of the whole and the limit to be applied to the whole results also any ideas?
|
by: Debbie link |
last post by:
I have an access query that is outputting to an excel spreadsheet. How do I hide the null colmns on the excel spreadsheet when it opens. Thanks
|
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: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
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: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
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: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
|
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: 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...
|