I recently posted a question which was answered by Allen Browne and gave me
some tips to structure the tables. However, when it comes to searching the
database, performance is unacceptably slow and I am now thinking of doing
the unthinkable with my tables and wonder whether anyone has used (or still
uses) this sort of approach.
The database stores libraries and classifies the types of book they keep. So
I have the classic 3-table design: tblLibrary, tblCategory, tblLibCat, which
is the junction table showing LibID and CatCode. Additionally, the CatCodes
are masked so that
050000 = Languages
050100 = European Languages
050101 = English
050102 = French
050103 = German
This enables me to ask "who stocks books on any European language?" as LIKE
"0501??". This was going OK until I tried to find out who stocks (maths and
physics) or (computers and philosophy). This did not sound an
overly-complex question to ask but as you may be able to guess from the SQL,
my pc went on strike for the next ten minutes, protesting mainly over the OR
clause. There are, by the way, about 25,000 libraries with about 80,000
junction table records.
SELECT * FROM tblLibrary WHERE
(LibID IN (SELECT LctLibID FROM tblLibCat WHERE LctCatCode LIKE "07????"))
AND
(LibID IN (SELECT LctLibID FROM tblLibCat WHERE LctCatCode LIKE "09????"))
OR
(LibID IN (SELECT LctLibID FROM tblLibCat WHERE LctCatCode LIKE "12????"))
AND
(LibID IN (SELECT LctLibID FROM tblLibCat WHERE LctCatCode LIKE "19????"))
So what I did (shock/horror) was to create a field tblLibrary.LibS ubjectList
which contained a comma-separated list of all the categories stocked e.g.
",070111,120100 ,120200,170602, " which is just the sort of thing you don't
normally do in a relational database, although I am keeping the junction
table as being the master list so I can always re-sync the subject list.
The query now becomes:
SELECT * FROM tblLibrary WHERE
(LibSubjectList LIKE "*,07????,* " AND LibSubjectList LIKE "*,09????,* " )
OR
(LibSubjectList LIKE "*,12????,* " AND LibSubjectList LIKE "*,19????,* " )
and performance is lightning quick. In fact, I can't ask a question about
which books are held which is not answered almost immediately. There are
some drawbacks though:
1. The SubjectList is a 255-character indexed text field which means the
maximum number of subjects per library is 36. That is, 6 characters per
subject plus a trailing comma multiplied by 36 then add a comma to the
beginning of the list gives 253 characters. This limitation is acceptable.
2. I cannot enforce referential integrity. Although I can always re-sync
the subject list with the junction table and the classifications should stay
virtually unchanged throughout the life of the database, it is still
something I need to be extremely cautious about. If the two lists don't
match, all the searching goes wrong.
3. I have never used this approach before, but no other seems to give
acceptable speed and I can't turn round and say (maths and physics) or
(computers and philosophy) is too difficult a question!
Any comments anyone? 4 1289
I don't know if this would help at all, but you may try re-wording your
LIKE statement. Would it make a difference if you used "07*" instead
of "07????" ?
This may keep the SQL engine from having to perform operations on
fixed-length strings and that may speed things up. Once it figures out
that the third digit is not correct, it does not need to check the
other three.
On a similar tach, you could try to parse the string before you do your
compare. Setup a few more key fields. Have one called "CatClass :
left(LctLibID,3 )" and another called "CatLevel: [LctLibID]" LangBreak
your WHERE clauses up between these different key fields. One for each
logical level for your code.
Just a few thoughts....
Alex.
Stefan Kowalski wrote: I recently posted a question which was answered by Allen Browne and
gave me some tips to structure the tables. However, when it comes to
searching the database, performance is unacceptably slow and I am now thinking of
doing the unthinkable with my tables and wonder whether anyone has used (or
still uses) this sort of approach.
The database stores libraries and classifies the types of book they
keep. So I have the classic 3-table design: tblLibrary, tblCategory,
tblLibCat, which is the junction table showing LibID and CatCode. Additionally, the
CatCodes are masked so that 050000 = Languages 050100 = European Languages 050101 = English 050102 = French 050103 = German
This enables me to ask "who stocks books on any European language?"
as LIKE "0501??". This was going OK until I tried to find out who stocks
(maths and physics) or (computers and philosophy). This did not sound an overly-complex question to ask but as you may be able to guess from
the SQL, my pc went on strike for the next ten minutes, protesting mainly over
the OR clause. There are, by the way, about 25,000 libraries with about
80,000 junction table records.
SELECT * FROM tblLibrary WHERE (LibID IN (SELECT LctLibID FROM tblLibCat WHERE LctCatCode LIKE
"07????")) AND (LibID IN (SELECT LctLibID FROM tblLibCat WHERE LctCatCode LIKE
"09????")) OR (LibID IN (SELECT LctLibID FROM tblLibCat WHERE LctCatCode LIKE
"12????")) AND (LibID IN (SELECT LctLibID FROM tblLibCat WHERE LctCatCode LIKE
"19????")) So what I did (shock/horror) was to create a field
tblLibrary.LibS ubjectList which contained a comma-separated list of all the categories stocked
e.g. ",070111,120100 ,120200,170602, " which is just the sort of thing you
don't normally do in a relational database, although I am keeping the
junction table as being the master list so I can always re-sync the subject
list. The query now becomes:
SELECT * FROM tblLibrary WHERE (LibSubjectList LIKE "*,07????,* " AND LibSubjectList LIKE
"*,09????,* " ) OR (LibSubjectList LIKE "*,12????,* " AND LibSubjectList LIKE
"*,19????,* " ) and performance is lightning quick. In fact, I can't ask a question
about which books are held which is not answered almost immediately. There
are some drawbacks though: 1. The SubjectList is a 255-character indexed text field which means
the maximum number of subjects per library is 36. That is, 6 characters
per subject plus a trailing comma multiplied by 36 then add a comma to
the beginning of the list gives 253 characters. This limitation is
acceptable. 2. I cannot enforce referential integrity. Although I can always
re-sync the subject list with the junction table and the classifications
should stay virtually unchanged throughout the life of the database, it is still something I need to be extremely cautious about. If the two lists
don't match, all the searching goes wrong. 3. I have never used this approach before, but no other seems to
give acceptable speed and I can't turn round and say (maths and physics)
or (computers and philosophy) is too difficult a question!
Any comments anyone?
"Alex" <al*********@ro cketmail.com> wrote in message
news:11******** **************@ f14g2000cwb.goo glegroups.com.. . I don't know if this would help at all, but you may try re-wording your LIKE statement. Would it make a difference if you used "07*" instead of "07????" ?
This may keep the SQL engine from having to perform operations on fixed-length strings and that may speed things up. Once it figures out that the third digit is not correct, it does not need to check the other three.
On a similar tach, you could try to parse the string before you do your compare. Setup a few more key fields. Have one called "CatClass : left(LctLibID,3 )" and another called "CatLevel: [LctLibID]" LangBreak your WHERE clauses up between these different key fields. One for each logical level for your code.
Just a few thoughts....
Alex.
Hi Alex
Thank you for your thoughts. Unfortunately they won't quite be enough to
make speed acceptable. Even if I do all the table indexing and even if I go
for an exact match (so no lengths to worry about), the OR clause just kills
it:
SELECT *
FROM tblLibrary
WHERE (LibID IN (SELECT LctLibID FROM tblLibCat WHERE LctCatCode="010 101"))
AND
(LibID IN (SELECT LctLibID FROM tblLibCat WHERE LctCatCode="010 102"))
OR
(LibID IN (SELECT LctLibID FROM tblLibCat WHERE LctCatCode="180 000"))
AND
(LibID IN (SELECT LctLibID FROM tblLibCat WHERE LctCatCode="190 000"))
Trying to run this query, then scroll to the bottom record takes 5 minutes
of locked pc, whereas the query using tblLibrary.Subj ect list is almost
instant. I think this is the approach I will take, but I wonder whether
anyone else currently uses this method. It is a problem which must occur in
other types of databases and although http://www.mvps.org/access/queries/qry0016.htm uses a 'helper table' to find
all of X having required Y, it does not address the OR issue.
Perhaps someone has a database with a similar 3-table structure, eg people
and skills. So you ask who knows (Access and VBA) OR (VB and SQL Server)
Somebody out there must be solving these types of queries. Stefan Kowalski wrote: I recently posted a question which was answered by Allen Browne and gave me some tips to structure the tables. However, when it comes to searching the database, performance is unacceptably slow and I am now thinking of doing the unthinkable with my tables and wonder whether anyone has used (or still uses) this sort of approach.
The database stores libraries and classifies the types of book they keep. So I have the classic 3-table design: tblLibrary, tblCategory, tblLibCat, which is the junction table showing LibID and CatCode. Additionally, the CatCodes are masked so that 050000 = Languages 050100 = European Languages 050101 = English 050102 = French 050103 = German
This enables me to ask "who stocks books on any European language?" as LIKE "0501??". This was going OK until I tried to find out who stocks (maths and physics) or (computers and philosophy). This did not sound an overly-complex question to ask but as you may be able to guess from the SQL, my pc went on strike for the next ten minutes, protesting mainly over the OR clause. There are, by the way, about 25,000 libraries with about 80,000 junction table records.
SELECT * FROM tblLibrary WHERE (LibID IN (SELECT LctLibID FROM tblLibCat WHERE LctCatCode LIKE "07????")) AND (LibID IN (SELECT LctLibID FROM tblLibCat WHERE LctCatCode LIKE "09????")) OR (LibID IN (SELECT LctLibID FROM tblLibCat WHERE LctCatCode LIKE "12????")) AND (LibID IN (SELECT LctLibID FROM tblLibCat WHERE LctCatCode LIKE "19????")) So what I did (shock/horror) was to create a field
tblLibrary.LibS ubjectList which contained a comma-separated list of all the categories stocked e.g. ",070111,120100 ,120200,170602, " which is just the sort of thing you don't normally do in a relational database, although I am keeping the junction table as being the master list so I can always re-sync the subject list. The query now becomes:
SELECT * FROM tblLibrary WHERE (LibSubjectList LIKE "*,07????,* " AND LibSubjectList LIKE "*,09????,* " ) OR (LibSubjectList LIKE "*,12????,* " AND LibSubjectList LIKE "*,19????,* " ) and performance is lightning quick. In fact, I can't ask a question
about which books are held which is not answered almost immediately. There are some drawbacks though: 1. The SubjectList is a 255-character indexed text field which means the maximum number of subjects per library is 36. That is, 6 characters per subject plus a trailing comma multiplied by 36 then add a comma to the beginning of the list gives 253 characters. This limitation is acceptable. 2. I cannot enforce referential integrity. Although I can always re-sync the subject list with the junction table and the classifications should stay virtually unchanged throughout the life of the database, it is still something I need to be extremely cautious about. If the two lists don't match, all the searching goes wrong. 3. I have never used this approach before, but no other seems to give acceptable speed and I can't turn round and say (maths and physics) or (computers and philosophy) is too difficult a question!
Any comments anyone?
Ok, so you have three tables. tblLibrary with key field LibID,
tblCategory with key field LctLatCode, and tblLibCat with no key field,
but multiple listings for LibID and LctLatCode. Why can't you just
join these in the normal manner and eliminate the sub-queries all
together?
Something like this (I probably don't have the field names correct,
though):
SELECT tblLibrary.*, tblLibCat.LctCa tCode
FROM (tblLibrary INNER JOIN tblLibCat ON tblLibrary.LibI D =
tblLibCat.LibID ) INNER JOIN tblCategory ON tblLibCat.LctCa tCode =
tblCategory.Lct CatCode
WHERE (((tblLibCat.Lc tCatCode)="*190 000")) OR
(((tblLibCat.Lc tCatCode)="*180 000")) OR
(((tblLibCat.Lc tCatCode)="*010 102")) OR
(((tblLibCat.Lc tCatCode)="*010 101"));
This eliminates the sub-queries and lets the joins take care of it. I
have never used a sub-query and don't really see the need to as long as
you can just join the tables together into a view.
I bet it is the sub-queries, not the OR statements that is slowing you
down. If you have 1000 records and you have subqueries, then you will
probably have 1000 * 1000 accesses to the database when you run the
query. The join should eliminate most of those at the fore-front.
Alex.
Stefan Kowalski wrote: "Alex" <al*********@ro cketmail.com> wrote in message news:11******** **************@ f14g2000cwb.goo glegroups.com.. .I don't know if this would help at all, but you may try re-wording
your LIKE statement. Would it make a difference if you used "07*"
instead of "07????" ?
This may keep the SQL engine from having to perform operations on fixed-length strings and that may speed things up. Once it figures
out that the third digit is not correct, it does not need to check the other three.
On a similar tach, you could try to parse the string before you do
your compare. Setup a few more key fields. Have one called "CatClass : left(LctLibID,3 )" and another called "CatLevel: [LctLibID]"
LangBreak your WHERE clauses up between these different key fields. One for
each logical level for your code.
Just a few thoughts....
Alex.
Hi Alex Thank you for your thoughts. Unfortunately they won't quite be
enough to make speed acceptable. Even if I do all the table indexing and even
if I go for an exact match (so no lengths to worry about), the OR clause just
kills it: SELECT * FROM tblLibrary WHERE (LibID IN (SELECT LctLibID FROM tblLibCat WHERE
LctCatCode="010 101")) AND (LibID IN (SELECT LctLibID FROM tblLibCat WHERE LctCatCode="010 102")) OR (LibID IN (SELECT LctLibID FROM tblLibCat WHERE LctCatCode="180 000")) AND (LibID IN (SELECT LctLibID FROM tblLibCat WHERE LctCatCode="190 000"))
Trying to run this query, then scroll to the bottom record takes 5
minutes of locked pc, whereas the query using tblLibrary.Subj ect list is
almost instant. I think this is the approach I will take, but I wonder
whether anyone else currently uses this method. It is a problem which must
occur in other types of databases and although http://www.mvps.org/access/queries/qry0016.htm uses a 'helper table'
to find all of X having required Y, it does not address the OR issue. Perhaps someone has a database with a similar 3-table structure, eg
people and skills. So you ask who knows (Access and VBA) OR (VB and SQL
Server) Somebody out there must be solving these types of queries. Stefan Kowalski wrote: I recently posted a question which was answered by Allen Browne
and gave me some tips to structure the tables. However, when it comes to searching the database, performance is unacceptably slow and I am now thinking
of doing the unthinkable with my tables and wonder whether anyone has used
(or still uses) this sort of approach.
The database stores libraries and classifies the types of book
they keep. So I have the classic 3-table design: tblLibrary, tblCategory, tblLibCat, which is the junction table showing LibID and CatCode. Additionally,
the CatCodes are masked so that 050000 = Languages 050100 = European Languages 050101 = English 050102 = French 050103 = German
This enables me to ask "who stocks books on any European
language?" as LIKE "0501??". This was going OK until I tried to find out who stocks (maths and physics) or (computers and philosophy). This did not sound an overly-complex question to ask but as you may be able to guess
from the SQL, my pc went on strike for the next ten minutes, protesting mainly
over the OR clause. There are, by the way, about 25,000 libraries with about 80,000 junction table records.
SELECT * FROM tblLibrary WHERE (LibID IN (SELECT LctLibID FROM tblLibCat WHERE LctCatCode LIKE "07????")) AND (LibID IN (SELECT LctLibID FROM tblLibCat WHERE LctCatCode LIKE "09????")) OR (LibID IN (SELECT LctLibID FROM tblLibCat WHERE LctCatCode LIKE "12????")) AND (LibID IN (SELECT LctLibID FROM tblLibCat WHERE LctCatCode LIKE "19????")) So what I did (shock/horror) was to create a field
tblLibrary.LibS ubjectList which contained a comma-separated list of all the categories
stocked e.g. ",070111,120100 ,120200,170602, " which is just the sort of thing
you don't normally do in a relational database, although I am keeping the junction table as being the master list so I can always re-sync the subject list. The query now becomes:
SELECT * FROM tblLibrary WHERE (LibSubjectList LIKE "*,07????,* " AND LibSubjectList LIKE "*,09????,* " ) OR (LibSubjectList LIKE "*,12????,* " AND LibSubjectList LIKE "*,19????,* " ) and performance is lightning quick. In fact, I can't ask a
question about which books are held which is not answered almost immediately.
There are some drawbacks though: 1. The SubjectList is a 255-character indexed text field which
means the maximum number of subjects per library is 36. That is, 6
characters per subject plus a trailing comma multiplied by 36 then add a comma to the beginning of the list gives 253 characters. This limitation is acceptable. 2. I cannot enforce referential integrity. Although I can
always re-sync the subject list with the junction table and the classifications should stay virtually unchanged throughout the life of the database, it is
still something I need to be extremely cautious about. If the two lists don't match, all the searching goes wrong. 3. I have never used this approach before, but no other seems to give acceptable speed and I can't turn round and say (maths and
physics) or (computers and philosophy) is too difficult a question!
Any comments anyone?
"Stefan Kowalski" <a@b.com> wrote in
news:ct******** **@sparta.btint ernet.com: Hi Alex Thank you for your thoughts. Unfortunately they won't quite be enough to make speed acceptable. Even if I do all the table indexing and even if I go for an exact match (so no lengths to worry about), the OR clause just kills it: SELECT * FROM tblLibrary WHERE (LibID IN (SELECT LctLibID FROM tblLibCat WHERE LctCatCode="010 101")) AND (LibID IN (SELECT LctLibID FROM tblLibCat WHERE LctCatCode="010 102")) OR (LibID IN (SELECT LctLibID FROM tblLibCat WHERE LctCatCode="180 000")) AND (LibID IN (SELECT LctLibID FROM tblLibCat WHERE LctCatCode="190 000"))
I'm too tired to see if this will work, in that it involves
nesting IN statements, but
SELECT *
FROM tblLibrary
WHERE (LibID IN (SELECT LctLibID FROM tblLibCat WHERE
LctCatCode IN ("010101","0101 02","180000","1 90000"))
might do.
Bob Q
Trying to run this query, then scroll to the bottom record takes 5 minutes of locked pc, whereas the query using tblLibrary.Subj ect list is almost instant. I think this is the approach I will take, but I wonder whether anyone else currently uses this method. It is a problem which must occur in other types of databases and although http://www.mvps.org/access/queries/qry0016.htm uses a 'helper table' to find all of X having required Y, it does not address the OR issue. Perhaps someone has a database with a similar 3-table structure, eg people and skills. So you ask who knows (Access and VBA) OR (VB and SQL Server) Somebody out there must be solving these types of queries. Stefan Kowalski wrote: I recently posted a question which was answered by Allen Browne and gave me some tips to structure the tables. However, when it comes to searching the database, performance is unacceptably slow and I am now thinking of doing the unthinkable with my tables and wonder whether anyone has used (or still uses) this sort of approach.
The database stores libraries and classifies the types of book they keep. So I have the classic 3-table design: tblLibrary, tblCategory, tblLibCat, which is the junction table showing LibID and CatCode. Additionally, the CatCodes are masked so that 050000 = Languages 050100 = European Languages 050101 = English 050102 = French 050103 = German
This enables me to ask "who stocks books on any European language?" as LIKE "0501??". This was going OK until I tried to find out who stocks (maths and physics) or (computers and philosophy). This did not sound an overly-complex question to ask but as you may be able to guess from the SQL, my pc went on strike for the next ten minutes, protesting mainly over the OR clause. There are, by the way, about 25,000 libraries with about 80,000 junction table records.
SELECT * FROM tblLibrary WHERE (LibID IN (SELECT LctLibID FROM tblLibCat WHERE LctCatCode LIKE "07????")) AND (LibID IN (SELECT LctLibID FROM tblLibCat WHERE LctCatCode LIKE "09????")) OR (LibID IN (SELECT LctLibID FROM tblLibCat WHERE LctCatCode LIKE "12????")) AND (LibID IN (SELECT LctLibID FROM tblLibCat WHERE LctCatCode LIKE "19????")) So what I did (shock/horror) was to create a field
tblLibrary.LibS ubjectList which contained a comma-separated list of all the categories stocked e.g. ",070111,120100 ,120200,170602, " which is just the sort of thing you don't normally do in a relational database, although I am keeping the junction table as being the master list so I can always re-sync the subject list. The query now becomes:
SELECT * FROM tblLibrary WHERE (LibSubjectList LIKE "*,07????,* " AND LibSubjectList LIKE "*,09????,* " ) OR (LibSubjectList LIKE "*,12????,* " AND LibSubjectList LIKE "*,19????,* " ) and performance is lightning quick. In fact, I can't ask a question
about which books are held which is not answered almost immediately. There are some drawbacks though: 1. The SubjectList is a 255-character indexed text field which means the maximum number of subjects per library is 36. That is, 6 characters per subject plus a trailing comma multiplied by 36 then add a comma to the beginning of the list gives 253 characters. This limitation is acceptable. 2. I cannot enforce referential integrity. Although I can always re-sync the subject list with the junction table and the classifications should stay virtually unchanged throughout the life of the database, it is still something I need to be extremely cautious about. If the two lists don't match, all the searching goes wrong. 3. I have never used this approach before, but no other seems to give acceptable speed and I can't turn round and say (maths and physics) or (computers and philosophy) is too difficult a question!
Any comments anyone?
--
Bob Quintal
PA is y I've altered my email address. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: O Ransen |
last post by:
Hello all, I hope you can help me.
Given graphical idea for a page:
http://www.ransen.com/temp/temp.htm
(Large image, please be patient!)
What is the best way of constructing this page so that it does not
require Flash or frames or active-x? It has to work on Mac (for
|
by: James A. Donald |
last post by:
--
I am just beginning to get into CSS. I like to keep all
my html simple and generic looking.
I want to use a table, because I have, (gasp) tabular
data. I want it to look like a table. Not only that,
but I want it to look like a plain ordinary
uncomplicated vanilla table, to look like everyone
else's table.
|
by: Colleyville Alan |
last post by:
I am now using the Execute command to run SQL for action queries. When I
had them as saved queries, I would use DoCmd.SetWarnings False to allow the
queries to overwrite existing tables. when I use this code:
CurrentDb().Execute strMySql', dbFailOnError
I still get warnings that the table already exists.
Is there another command that I am supposed to use?
|
by: Kevin |
last post by:
Hi All
Can someone tell me if I am doing this correctly, or can possibly suggest better ways, if I'm not doing this correctly.
I have a windows application that I am writing,So I have a UI and I have another class that handles the inserts,updates etc to a specific table/s in the database,(I actually have multiple classes that do more or less the same thing, but for different sets of tables in the database) Then in my UI code I have a...
|
by: Aaron Ackerman |
last post by:
I cannot a row to this bound DataGrid to SAVE MY LIFE! I have tried
everything and I am at a loss. The using goes into add mode with the add
button adds his data then updates with the update button, seems simple.
I am using ALL visual controls (supposedly to simplify things. If I was not
using the visual controls and calling an ExecuteNonQuery no prob.
Please look at my code and tell me what I am doing wrong. Also, what are the
advatages...
| |
by: Joe Van Meer |
last post by:
Hi all,
I have a page that fills a dataset with 3 tables, relations are created and
now I am just simply trying to display the number of returned records from
one of the tables in the dataset and display that number on a label on my
webpage. I am having probs accomplishing this task to my surprise.
I have tested this value and am able to print it out at the top of my page
.... this is marked below with ***
|
by: Shapper |
last post by:
Hello,
I am trying to create a dataset by adding rows to it in a For loop:
Dim dsNews As DataSet = New DataSet()
Dim row As DataRow = dsNews.Tables(0).NewRow()
dsNews.Tables.Add
dsNews.Tables(0).Columns.Add("title", GetType(String))
dsNews.Tables(0).Columns.Add("description", GetType(String))
|
by: cjobes |
last post by:
Hi all,
The code below is part of a form where I would like the user to make
selections from a table. The data is brought into the form from another form
with:
Public WriteOnly Property DataSet() As DataSet
Set(ByVal Value As DataSet)
ResultGrid.DataSource = Value.Tables("tbSelect")
End Set
End Property
|
by: Roy |
last post by:
Hi Access gurus,
I have a A2K application.The data in the database is updated daily by a
excel download.I have a master n related tables keyed in by a OrderID.I
have a problem in updating data.If it is a one to one update,i face no
problem as I update every fields.But let's say if there is a master
record with ID and three corresponding related entries for this on day
1.But on the next day,there was a change on related records 2 & 3 but...
|
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: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
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: 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: 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: 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...
| |